SQL Newsgroups: Microsoft SQL Server Administration

Can I ship database developed in SQL Server 2005 to customer ?

Jigar - 17 Jun 2006 8:54 PM - 3 messages

Hi, I want to ask a question whether I can ship the database created in SQL Server 2005 to customer along with installation for free of cost or not (just like mySQL) ? Will I have to pay something to anybody for this ? ...

datetime field overflow

Hassan - 17 Jun 2006 7:42 PM - 2 messages

Why would i get a "datetime field overflow" error ? Under what conditions ? Thanks ...

Does anyone use more than 256 worker threads ?

Hassan - 17 Jun 2006 7:41 PM - 3 messages

If so, why and how much more than 256 have you set or recommend to set without causing too much of a performance degradation ? I am thinking 384 for our environment due to the fact that we have a lot of transactions/sec ...

16GB of RAM and 32 bit SQL

Hassan - 17 Jun 2006 7:38 PM - 9 messages

If I have 16GB of RAM and just the 32 bit SQL Server 2000 running with AWE enabled, what is an ideal max amount of memory I should set for SQL ? 12GB or 14GB ? ...

Why I get mysql error error while opening page?Line: 131 of /ips_kernel/class_db_mysql.php

Thaqalainnaqvi - 17 Jun 2006 6:41 PM - 2 messages

IPB WARNING [2] mysql_connect() [function.mysql-connect]: Too many connections (Line: 131 of /ips_kernel/class_db_mysql.php) There appears to be an error with the database. You can try to refresh the page by clicking here. Error Returned SQL error: Too many connections ...

Indexes getting fragmented very quickly

Jayme - 17 Jun 2006 6:27 PM - 13 messages

We have been running SQL Server 2000 on a production machine for years. Within the last 6 months, we have noticed a performance problem. The system will suddenly slow to a crawl. We run DBCC Reindex for all of ...

database is maked suspect

roberto segoviano - 17 Jun 2006 5:46 PM - 3 messages

I received the next error message in error.log: bypassing recovery for database 'aries' because it is maked SUSPECT Anyone can help me to know what it is the problem and how I can resolve it ?? Thanks a lot Roberto Segoviano ...

q: SP name in the trigger

JIM.H. - 17 Jun 2006 4:34 PM - 2 messages

There are two different Stored Procedures insert data into a table, is it possible to catch what stored procedure name was that trigged the trigger in the trigger? ...

Process Details/Last TSQL command batch for SPID

Dan - 17 Jun 2006 3:34 PM - 2 messages

Is there a way to view the "Process Details/Last TSQL command batch" for a given SPID from Query Analyser? In EM if you go to > Managment > Current Activity > Process Info > and then double click on a SPID, you can view the ...

Runtime error while installing SQL 2005 Standard Edition

Kay - 17 Jun 2006 1:34 PM - 2 messages

Dear All, I have an instance of SQL 2000 and while Installing another instance of SQL Server2005 Standard Edition on Windows 2003 with SP1 on Dell Server, I am getting error Microsoft Visual C++ Runtime Library ...

Sql Server 2000 with Power builder 6.0 locking problem

Rengaswamy Jayaprakash - 17 Jun 2006 6:59 AM - 2 messages

Dear sir/madam, We have archieture of Sql server 2000 with power builder 6.0. we are facing locking problem frequently. kindly provide to identify the reason for locks. *** Sent via Developersdex [link] *** ...

Primary Key falling short

Ravi - 17 Jun 2006 5:42 AM - 3 messages

Plz tell me what to do if Primary key fall short and execed the max size of the datatype like integer with Identity increment option. ...

Remote SQL Trace causing network slowness

imarchenko - 17 Jun 2006 2:07 AM - 3 messages

Hello! I was running SQL Trace from my computer (remotely) and noticed that all activities against this server are slowing down. Queries that normally takes a sec to execute are taking much longer. Once I stop trace, everything is ...

Job Scheduling question

Big Ern - 16 Jun 2006 10:18 PM - 2 messages

I think I know the answer to my question, but I thought I would ask to be sure that I'm correct. I have a need to run a job every 30 seconds, but the Job Scheduler only gives the option of a frequency of 1 minute. Is there ...

Installing Express on box that already has Developer Edition

AlBruAn - 16 Jun 2006 9:20 PM - 3 messages

I'm not at all certain I need to install SQL Server 2005 Express Edition on my box, but I thought I'd post this anyway. I currently have SQL Server 2005 Developer Edition installed on my box and am using it to develop a commercial website I hope to deploy within the next ...

Replacing SQL Server.

ChrisR - 16 Jun 2006 6:06 PM - 3 messages

SQL2K SP3 Tonight we are replacing one of our SQL Servers. The data already resides on the same SAN that we want it on, and our new box is already built and has an OS installed, so here is our plan. ...

Error Message 11004

atsioplakis - 16 Jun 2006 6:04 PM - 4 messages

Hi Eveyone. I am having trouble connecting to my SQL Server 2005 Expression edition. I can connnect from other pc without any trouble. The only difference between this PC and the others is this PC is running Windows 2000 SP4. I can ping my SQL Server no problem. I can ...

Linked server to FoxPro - permissions

ddavis - 16 Jun 2006 6:01 PM - 17 messages

I set up a linked server and it is working great......when i'm logged in under the same account that SQL runs under (also the account that i set up the linked server as, if it matters). However, if i'm logged in as anyone ...

is "office 2003 web components" needed on SQL 2005 ???

bajopalabra - 16 Jun 2006 4:40 PM - 2 messages

hi on control panel appears "office web 2003 componentes" .... does a server running Sql Server 2005 need that module ? if not, i think i can uninstall it safely ( right ? ) i guess it has installed via windows update ... thanks ...

Dropping a file in a filegroup that does not exist.

Henry - 16 Jun 2006 3:46 PM - 4 messages

Hi, I moved a database from an older sql box to one of our new servers. One of the files in the prmiary file group was not moved and the server was wiped... the filename is sysft_ix_STS_neo_1414639615. Everytime I try to do a backup ...

Performance question: Opteron Dual core vs Xeon

Bastian - 16 Jun 2006 3:13 PM - 4 messages

Hello, we are looking for new systems to run SQL20005 on Windows 2003 64-bit.. Our supplier made a proposal of two machines. Number one: HP Proliant DL585 (R01) with 4x Opteron - 2.2 Ghz - 1 MB cache and 8 GB ...

copy databases

Per W. - 16 Jun 2006 2:03 PM - 3 messages

Hi, how can i copy databases from one server in one domain to another server. Since the servers isnt in the same domain its not possible to do with the copy in enterprise manager (even with same username and password on ...

DBCC SHRINKDATABASE Errors Running SQL Server 2000 , SP3a

DuncanJ - 16 Jun 2006 1:45 PM - 2 messages

I am running SQL Server 2000 SP3a on Windows 2003 I get the following error when I run DBCC SHRINKDATABASE [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionCheckForData (CheckforData()). Server: Msg 11, Level 16, State 1, Line 0 General network error. Check your network documentation. ...

Reading image columns from SQL Server

ipramod - 16 Jun 2006 12:20 PM - 6 messages

Hi, I am having a SQL Server table which has the following column value and the column datatype is image. 0xFFFFFFFF020000001901000009000000DD0000001E0000000000000046000000240032003100200024003A0020002000240032003200200024003A0020002000240032003300200024002000760061006C007500650020003D002000240032003500200024002A000000240032003100200024003A00200020002400320032 How can I convert the above image data into string? This is just a ...

SQL2000 Encryption in T-SQL "with encryption" option

Dimitris Ioannou - 16 Jun 2006 12:20 PM - 5 messages

Hello All, I was informed that there are some programs that crack the built-in encryption program in SQL2000. So this is serious problem and all encrypted programs in T-SQL, would be copy or would be changed. Any suggestion or solution or PATCH in SQL2000 to block the decryption of ...

Urgent Help Needed

Peter Newman - 16 Jun 2006 8:59 AM - 3 messages

i havebeen contacted by one of my clients who has a major problem. They have not run any backups on there SQL2000 server, and have found that there main database has appeared suspect. I have managed to grab the data file and log file .. but am at a loss as to ...

Authentication

Alan - 16 Jun 2006 7:07 AM - 7 messages

I just wonder my office server setup: In EM: 1) Right click the instance, select 'Edit SQL Server Registration properties...' 2) The 'Use Windows authentication' radio button is selected 3) Right click to select the instance, select 'Properties' 4) Security tab ...

Database port

Alan - 16 Jun 2006 5:55 AM - 8 messages

What port does SQL Server 2000 is using for connection ? What I want to do is I want to connect my application from my home machine to my office server, so I need to open the port in my office server. ...

How to free up the space ...

Atenza - 16 Jun 2006 4:18 AM - 7 messages

Hi all, I have a table with column A char(1000) and then alter the table to varchar(1000) and update tableA set A = rtrim(A) I know a stupid way to free up the space by create a new table and move the ...

Corrupt Database/file

sqldba - 16 Jun 2006 3:42 AM - 3 messages

i have 5 database that got corrupted & error message is Torn page. after doing Hard Disk(HD) diagonistic there are some bad sector & finally decided to replace HD with NEW.here is what i want to understand & my question is. ...

Msg 15404

Richard - 16 Jun 2006 1:53 AM - 3 messages

Can someone tell me specifically what the following error means, and then, if there's more to it, what some of the possibilities are for this error when executing a SQL command, such as "xp_logininfo [mydomain\myusername]" from Query Analyzer? That command works on some SQL Servers, and not on ...

MSDASQL out-of-process Linked Server problem

Howard - 15 Jun 2006 11:46 PM - 10 messages

MSDASQL fails with the following error when "allow inProcess" is not selected, and a remote stored procedure is executed. In my testing, the problem occurs on SQL 2000 SP3a, and SP4, as well as SQL 2005 SP1. Server: Msg 7212, Level 17, State 1, Line 1 ...

Troubleshoot sp_OACreate on SQL Server 2000

Dave - 15 Jun 2006 11:34 PM - 5 messages

I have no option but to support a legacy app using the OLE Automation Stored Procedures. I configure the DLL to run under DCOM so that on my SQL Server box I have a proxy that makes a call to the actuall DLL on another server. ...

How to Test Log shipping?

shane - 15 Jun 2006 10:27 PM - 3 messages

Hi, How do I test that the secondary server can come online, and then just contiune the log shipping ot the secondary once the test is done? I know I can always copy the primary db and start over again, but over ...

q: an insert

JIM.H. - 15 Jun 2006 9:59 PM - 2 messages

Hello, I need to realize an insert something like the following: Exec GetMyID @tName, @MyId OUTPUT INSERT INTO MyTable2 (MyId,MyName) SELECT @MyId,MyName FROM MyTable1 ...

Index Usage...

theredmiata - 15 Jun 2006 9:30 PM - 6 messages

All, I'm a new DBA and in the process of reviewing an application and reducing the number of indexes because the increase in the amount of time it takes to perform an insert. and have a question on indexes and ...

SQL Server 2000

BM - 15 Jun 2006 8:52 PM - 2 messages

I have personal edition running on Windows XP SP 2. When I open Enterprise Manager, I get a general fault and SQL E. M. has to close. I have opened a new console, added MS SQL, and tried to re-register, but that didn't work. I ...

How to find all sql servers in a domain

Rob - 15 Jun 2006 8:35 PM - 5 messages

Hi, Is there a way to find all available SQL Servers in a particular domain or subnet? Thanks. - Rob. ...

Stored Procedure Priming

Donald Sweat - 15 Jun 2006 8:01 PM - 4 messages

Hello, I am getting the following error. Have been for some time. The job fails with the following errors below. The job runs under the local Windows Admin account wich is an owner of the DB. I am not a newbie to SQL neither am I ...

blob size limit

jason - 15 Jun 2006 7:36 PM - 3 messages

is there a size at which the items just get too big to be practically stored in blobs? ...

DTS Question

shub - 15 Jun 2006 7:02 PM - 6 messages

I am using SQL Server 2000 and I have a created a DTS package that copies Data from a Excel Spreasheet to a SQL Server table then executes a user Stored Proc What I am wanting to do is if for some reason the Stored Proc errors ...

SQLCLR

Greg Larsen - 15 Jun 2006 5:23 PM - 6 messages

I'm researching SQLCLRs and trying to determining the does and the don'ts and wonder what other DBA's are doing in regards to SQLCLRs. I'm expecially interested in SQLCLRs that require "PERMISSION_SET = UNSAFE". As a DBA I'm trying to develop some guideline as to what is acceptable when ...

MS query

Chriske911 - 15 Jun 2006 5:07 PM - 8 messages

when I try to get some data thru MSQuery into Excel 2003 I see in SQL profiler that those queries have a duration of several minutes and a CPU usage of around 80 percent even though it is a very simple straightforward select from a join on 2 ...

Linked Server - Access

Amit - 15 Jun 2006 4:33 PM - 2 messages

Hello there, I have a situation where we need to transfer data from Sqlserver database to an Access database on hourly basis. These databases have to be on separate machines. This access database is used across 3-4 locations as a backend for a ...

Aggregate Case Conditions

Rajeev - 15 Jun 2006 4:26 PM - 2 messages

I have a table AAA which contains two columns fileid and typecd for single fileid there can be either 1, 2 or 3 typecds home, host and payroll for e.g. Fileid Typecd 100 Home ...

sql 2000 sp4

Pietro Pesce - 15 Jun 2006 3:58 PM - 2 messages

how i can see if the sp4 is istalled on my sql server 2000? ...

Read-only Stored procedure Display in SQL 2005

Ron - 15 Jun 2006 3:34 PM - 6 messages

In sql 2000 the development team could look at the contents of an SP in enterprise manager when they had read only access to the database. The same does not hold true to sql 2005 and the management studio. How do ...

Jobs don't run and are stuck with request pending

Superflous - 15 Jun 2006 3:27 PM - 3 messages

Hi, I am running SQL Server 2K,Developer Edition, SP4, The problem is in the SQL job scheduler. I have 450 jobs that run every minute. Only 60 jobs Run and rest are stuck with pending request status. 1) I have increased the worker threads to 100 and 200 with no ...

Violation of Primary Key constraint. Cannot insert duplicate key in object.

Bluenose - 15 Jun 2006 3:27 PM - 3 messages

Hello, Im trying to insert values into a MS SQL Server 2000 DB table from an Excel spreadsheet, using the DTS Import Wizard The following error message occurs. "Violation of Primary Key constraint 'PK_tbl_X'. Cannot insert duplicate key in object 'tbl_X'." ...

Error After SQL Server 2005 SP1

BDB - 15 Jun 2006 3:08 PM - 10 messages

SQL Server 2005 SP1 Build 2153 Developer Edition on Windows 2003 Server SP1 When I start the SQL Server service I get: [298] SQL Server Error: 2812, Could not find stored procedure 'msdb.dbo.xp_sqlagent_notify'. [SQLSTATE 42000] (DisableAgentXPs) Any ideas? ...

SQL Timeout ConnectionRead (WrapperRead())

haibhoang - 15 Jun 2006 2:40 PM - 2 messages

We have several window services that process files every night. Since we moved to the new server, which has identical configuration settings to the old server but we keep getting sql time out error. On average, we get about 3 per night out of 100,000 connections to the database. ...

The Redo queue

Kevin Jackson - 15 Jun 2006 2:02 PM - 3 messages

I would l ike to get some feedback from others that have mirrored databases and the bytes per second on the playback of the redo queue on the mirror. We run the mirror in asynch mode and our redo queue gets pretty backed up at ...

How to create a Database in SQL 2005 by using a txt file.

DMI - 15 Jun 2006 1:57 PM - 2 messages

Good morning - I have a text file with the information on how to create a database, the relationship between tables, etc. I am new to SQL 2005. What I would like to do is to create the database and structure by using this ...

High number of Page Faults

Svein Terje Gaup - 15 Jun 2006 1:43 PM - 5 messages

Hi, I have a SQL Server 2000 with 14 different databases. I have been monitoring it for some time, and it seems there is a high number of page faults occurring. The number is constantly above 3000. The server has 3 Gigabytes of RAM, and there's about 600+ megs free at all times. ...

Error running DBCC SHRINKDATABASE Msg 8966

Jeremy - 15 Jun 2006 1:25 PM - 3 messages

When running DBCC SHRINKDATABASE on a SQL 2005 database the command returned the following error: Msg 8966, Level 16, State 2, Line 1 Unable to read and latch page (1:6470400) with latch type SH. Latch failed. DBCC CHECKDB() did not reveal any problems and the database is functioning ...

error 3271

Rodger - 15 Jun 2006 1:01 PM - 2 messages

Hi I am trying to do a backup of a database and it gives me the following error Nonrecoverable I/O error occurred on file 'C:\Program Files\Websense Reporter\wslogdb61.mdf'. [SQLSTATE 42000] (Error 3271) I ran dbcc checkdb and it gives consistency errors on one of the table, i ...

How to Stop Logging?

Raj - 15 Jun 2006 12:39 PM - 5 messages

is it possible to stop logging in sql server? if it is how we can do that? Regards! Raj ...

Create views only if database exists

Dave - 15 Jun 2006 9:48 AM - 7 messages

Hi, I have a script that I execute, which checks whether a database exists, I wish to then only create the views if this DB exists. I have been attempting to use return, like this: if not exists(SELECT 1 FROM INFORMATION_SCHEMA.SCHEMATA WHERE ...

Update SP4 in SQL Server 2000

sunkers - 15 Jun 2006 9:32 AM - 2 messages

Hi All, currently i have a problem update SP4 in Windows 2003. in our server there are 2 SQL server: 2000 & 2005 & share point. Error Message: MSSQL is not a SQL server 2000 instance, Setup will now exit ...

connection pooling

Jason - 15 Jun 2006 6:41 AM - 4 messages

Hi, Is there a way to do maintenance like integrity checks if there is still a (sleeping)connection to a database? My maintenance jobs where you need to be in single user mode fails. In our multi-tier environment we use an ...

T-SQL Grammar

Diego L Espiñeira - 15 Jun 2006 2:48 AM - 2 messages

Hi! Anyone knows where could I find the Transact-SQL grammar in BNF form? It whould be very usefull to me, in fact it would save my job!! I'm currently migrating code between different DB engines. I really need ...

Renaming a named instance of SQL Server 2005

broy - 15 Jun 2006 12:04 AM - 12 messages

I installed a named instance of SQL Server 2005 on a machine...let's say I called it VAIO4. I want to rename it to BTSERVER. I'd rather not have to uninstall and reinstall, but will do that if I have to. Is ...

SSIS - LinkedServers

tboogerd@gmail.com - 14 Jun 2006 7:31 PM - 2 messages

I have a linked server to a progress database using the merant ODBC driver. When I run this T-SQL update command set transaction isolation level serializable; go update openquery(progress, 'select ProdCode from PUB.Part where Class=''013'' and ProdCode='' ''') ...

SSIS - Where is the Workflow

DXC - 14 Jun 2006 6:58 PM - 7 messages

Where is the workflow (on completion, on success, on failure) on SQL Server 2005 that we had on SQL Server 2000 ?. Is there an alternative ? Thanks. ...

OS requirements for MSSQL2K5.

ChrisR - 14 Jun 2006 6:18 PM - 4 messages

Can 2005 be installed on XP Media Center Edition? I looked on the SQL site, but it only references Windows XP, not this particular version. TIA, ChrisR ...

locking SQL command

Aleksander Stukov - 14 Jun 2006 4:46 PM - 5 messages

Hi there!, I'm trying to track down a random lock in SQL Server 2000, but all my efforts are futile. What I really need is the locking SQL command, and looking around in SQL Server's internal procedures I found things like ...

problem with index and duplicates

Dariusz Tomon - 14 Jun 2006 4:42 PM - 3 messages

Hi I'm trying to change structure of table 'TB_KONTAKT' to add a fiew fields - but during that I get the following error message: 'TB_KONTAKT' table - Unable to create index 'PK__TB_KONTAKT__04AFB25B'. ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE UNIQUE ...

Moving data between old db and new db

SerbianEagle - 14 Jun 2006 4:01 PM - 4 messages

Here is the situation, I've been searching for some advice with a data conversion that I have to do. Using : MS SQL server 2000 Old DB: many tables and no relationships originally. They were added afterwards and before my time here. ...

sp_help_revlogin prob

gracie - 14 Jun 2006 3:19 PM - 2 messages

I'm in the process of moving 2 databases to a new server. I first ran the sp_help_revlogin SP and created the new logins on new server. There were only a couple. I restored the 2 databases. I can connect to the new server with the previous logins/passwords from the ...

Dialup Dead - Slammered again?

realraven2000 - 14 Jun 2006 2:58 PM - 2 messages

HI I am trying to logon to a remote server with Enterprise Manager via dialup, which worked fine for the last 6 months. I can connect to the server but Now I am getting the egg timer for ever when expanding the ...

QA simple question

Dariusz Tomon - 14 Jun 2006 2:32 PM - 5 messages

Hi I'm a new MS SQL user. When I'm using QA it shows erros in such a way: "Server: Msg 156, Level 15, State 1, Procedure XX_IMPORT, Line 45 Incorrect syntax near the keyword 'select'." I wonder how to force it to show correct line. In the example above I ...

how i can make script Database with Data?

Tark Siala - 14 Jun 2006 1:57 PM - 2 messages

hi i am working on Windows 2000 Advanced Server + SP4 and SQL2000 Enterprise + SP4. i have database contains Tables, and i want make script to build Tables on other Database, but i need this script include Data in Tables too, i can make that ? and ...

Sql server query dude

Josema - 14 Jun 2006 11:59 AM - 3 messages

Hi to all, Im using a query like this: select A.AfectadoApellidos as Apellido, A.AfectadoName, A.AfectadoDNI,(Convert(varchar,TA.TipoAccionBreve)+Convert(varchar,Empresas.EmpresaBreve)+Convert(varchar,E.ExpedienteIncidenciaID)) as Codigos from Expedientes E inner join Afectados A on E.AfectadoID=A.AfectadoID ...

ANN: Multi DBMS tool "Database Workbench" version 2.8.7 released

Martijn Tonies - 14 Jun 2006 8:02 AM - 2 messages

Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular database development tool: Database Workbench 2.8.7 has been released today! Download a trial at: [link] What's new?: [link] ...

Pros and cons of having multiple DBMS in the organization

Hassan - 14 Jun 2006 2:39 AM - 4 messages

I just want to know how does a database manager go about with having multiple RDBMS in the organization. As we acquire new companies and have to manage them all ( Im not a manager, but would like to be some day) , what do ...

Case sensitive problem

bad_boyu - 14 Jun 2006 12:34 AM - 7 messages

Hello, I have a very.. very.. very big database that has a table with let's say column "Function". I want to do different selects on this column "Function". This select must be case sensitive, so if i do a select ...

Transaction log Full - SQL Server 2005

Srikanth - 14 Jun 2006 12:03 AM - 4 messages

Hi My database is was not enabled for replication. Revovery model is simple. My log is growing and filling drive space. I verified log_reuse_wait_desc it is showing replication, why it is showing replication? How can i set this one to NOTHING. ...

Can't use Profiler to get execution plan for a particular query

pshroads - 13 Jun 2006 11:37 PM - 9 messages

I am trying to troubleshoot some performance problems and I am trying to set up Profiler so that I can look at the execution plan of a particular stored procedure. I am using the ExecutionPlan event class in the Performance event category. I am also setting up a filter on ...

users quota

Eli Milkova - 13 Jun 2006 11:10 PM - 2 messages

Hi experts! Is there a way to configure quota for system resorces per user or user group? I know Oracle have Resource manager to deal with resorce allocation. What about sql2000 or sql2005? ...

Linked server - Access Denied

sellerss - 13 Jun 2006 11:08 PM - 4 messages

I have a problem that I am having a heck of a time figuring out. I have a new install of SQL Server 2005 on a new install of Windows 2003. I installed the Informix CSDK 2.90.xxx and set up connections to our test ...

sp_recompile and freeproccache

jxstern - 13 Jun 2006 9:28 PM - 6 messages

Not quite the same things, are they? What I mean is, even if you say to sp_recompile an SP, it may still end up using a cached plan, right? There's no way to just clear the cache of plans for a particular SP, ...

Shared Database Environments (Consolidation)

Steve - 13 Jun 2006 9:28 PM - 3 messages

Hello My company is in aggressively pursuing consolidation of SQL Server environments into larger 'neighborhoods' of databases that cross business lines. I have been charged with a mission of determining 'rules' for applications that would want to place their databases in the neighborhood. ...

Database mirroring and raw partitions

MDBVV - 13 Jun 2006 8:58 PM - 2 messages

I have several servers that I am setting up using raw disk partitions for the data and log storage, and at the same time I am very interested in the new database mirroring technology in SQL 2005. My question and problem is this, ...

Linked server to foxpro - order by causing error

ddavis - 13 Jun 2006 8:26 PM - 2 messages

We're playing with linked servers to hopefully help us ease the migration from fox to sql. The first problem i've run into is with the "order by" clause. When running it against our test table, i get the following error: ...

Listing tables in a database

Rich - 13 Jun 2006 8:00 PM - 5 messages

Hello Group, how can I run a query in the QA to list the table names in a particular database? Rich ...

Modifying SQL Server 2005 Objects from Access 2002

Greg - 13 Jun 2006 7:26 PM - 3 messages

I just upsized a Microsoft Access 2002 backend database to Microsoft SQL Server 2005 using the Access Upsizing Wizard. The Upsizing Wizard created an ADP Project file for me and when I attempt to modify the design of any table or create a stored procedure I get the ...

Filegroup & .NDF Question

Jude - 13 Jun 2006 7:08 PM - 3 messages

How can I change the FILEGROUP on database properties? SQL Server 2000 I restored one database to create a new database, but the .ndf filegroup of the restored db has the name of the restored db. For example; DB 1 = TestDB1.mdf TestINDX1.ndf TestLog1.ldf ...

SQL2005 Express

Dave - 13 Jun 2006 7:01 PM - 3 messages

Can I use SQL2005 Express GUI to manager Ms SQL2005 or Ms SQL2000 Server? Is there any limition? ...

search stored procedure code

Dan D. - 13 Jun 2006 5:59 PM - 5 messages

Using SS2000 SP4. I have a list of tables that don't have indexes. I'd like to search all stored procedures for these table names so I can see how the tables are being accessed. Is the code for stored procedures stored in the system tables? If so how can ...

making an item repeat

hero281 - 13 Jun 2006 5:51 PM - 5 messages

i have created a sql database with a vb.net front end. i have records that databse that have dates attached. i want each record to repeat in a given time frame according to a field in the datarow. is it possible. ...

Not sure if restore to point in time can be done

Michael - 13 Jun 2006 5:22 PM - 3 messages

Hi, We are trying to get a SQL Server 2000 database to restore to a point in time of almost a month ago due to issues that have occurred. However, we do not have any backups at or prior to that point in time, only afterward; daily ...

SQL Server locks up

meenal - 13 Jun 2006 4:52 PM - 3 messages

We are running SQL server 2000 sp 3 (8.00.760) on Windows NT. Recently for 2 nights in a row the server just locked up and you could not get to it in anyway - the only thing we could do was a hard re-boot. There ...

How to bypass log file ?

Rob - 13 Jun 2006 4:42 PM - 3 messages

I am basically archiving some data from one db to another.... This process causes a great increase in the size of the log file. Any way to do the row transfer without affecting the size of the log file ? I have ...

How to change the default BCP row batch size from 1000 to 10,000 records

Maxwell2006 - 13 Jun 2006 4:05 PM - 4 messages

Hi, When I use BCP, it shows a progress log like this: Starting copy... 1000 rows successfully bulk-copied to host-file. Total received: 1000 1000 rows successfully bulk-copied to host-file. Total received: 2000 1000 rows successfully bulk-copied to host-file. Total received: 3000 ...

BCP table export and Shared Locks

Maxwell2006 - 13 Jun 2006 4:01 PM - 5 messages

Hi, We use BCP commands like this: BCP ACC.Dbo.[TableName] out CSV\ TableName.csv /c /k /t "|" /r "\n" -Sservername -Uname -Ppass to extract data from SQL Server into CSV files. I want BCP don't put any lock, including shared lock, on table records. How ...

Need Help With Procedure

joey.powell - 13 Jun 2006 3:58 PM - 3 messages

Hello, I have three tables... PRODUCT ProductId IDENTITY(1,1) [Name] TOPIC TopicId IDENTITY(1,1) ProductId FK [Name] MESSAGE MessageId IDENTITY(1,1) TopicId FK UserId [DateTime] MessageText I need to be able to allow users to delete products. When this happens, ...

The Import and Export Utility ...

Chris Marsh - 13 Jun 2006 3:36 PM - 2 messages

Express 2005 apparently contains an "Import and Export Utility", not the Wizard like we get with the full version but at least a basic tool. Does anyone know where I find it? Thank you. ...

SQL users after DB restore

Stevan - 13 Jun 2006 3:26 PM - 3 messages

We have moved our databases across to a new SQL server & while the original users are still defined in the the individual users container under each database they do not appear in the 'security' logins containers & I cannot create new ones as they already exist. ...

Backup of transaction log

Alwin - 13 Jun 2006 3:23 PM - 4 messages

How to schedule backup of transaction log??? ...

SQL Express : Web Scalability

AJ - 13 Jun 2006 3:19 PM - 3 messages

Hi all, Simply question: Is SQL Express fit for use as a web DB Engine. The company i work for is thinking of migrating to ASP.NET and my recommendation is to use an SQL Server backend. Their techs are currently using MYSQL and am pretty much adverse to MS ...

Extended stored procedure, performance?

Processor Licensing question

Moving a log file while still "attached"

Express ... DTS or SSIS

Multiple SQL Instances and Server Specs?

q: insert trigger

I can't add a user in "Security/Logins"

SQL server backup and truncate log file

SQL 2000 and OSQL CREATE VIEW statements

Importing data from an SQL database to another on the same server

Fragmentation with large varchar column

Restoring a datatabase in Sql 2005

getting windows user

DB Free space and Log Free space

SQL help for ensuring an integer range is unique and valid?

using inserted & deleted tables

sqlcmd Missing Data Source Name

Upgrade from SQL2005 SP1 Standard to Enterprise

Troubleshoot memory leak

How to measure TPS...

users and their permission

SQL 2000 - SQL Agent failing - but can start manually

log stored procedure execution

Minimum perms for a user work with a db?

Restoring a Backup to another database

Transaction Logs

Query over Linked Server timing out

Enable SQL Server Remote Connections via Script

Log Shipping - SQL2000 and SQL2005

Error Nuimber 913 - Could not find database ID

Create Database With Attach in Restricted_user mode?

Cumulative max-length for index on SQL servers... please help

Reorganize index pages never completes

Live backups

Drop a constrain

viewing backup sets via query analyser

Insert missing items from a list

Insert into 10000+ tables

transaction log > 4 GB

Installing SQL Server on a SAN - any special requirements?

How to sequentially SORT numbers that also have a letter attached?

Database Encryption

Storage space help by a column

Server 2003 64-bit not showing SQL2005 perfmon counters

Enterprise Managers "current activity":How in SQL?

Maximum value a datetime datatype can hold

Best way to upgrade for SQLServer2000 standard to Enterprice

Trace data

Tool to run some sql statements concurrently

System messages not logged in 2K5?

Solomon

Strange behaviour in transaction on migrating from SQL 7 to SQL 2K

Driver for paradox

What is Database Engineering ?