I have a DTS that grabs data from Oracle 9.2 into SQL 2000. If I run the DTS, everything works fabulous. The problem is running this DTS in a job in SQL Agent. The job just stop at the point of connecting to Oracle(I think). The status just hang at "Executing.." never finished. Can someone g...more >>

I know this is not a SQL question, but I use SQL and i know we have a max cap on 32000 user connections and 256 worker threads(ideal setup ) Does Oracle have such a limitation ? Thanks ...more >>

Hi, I'm running SQL Sever 2000 SP4 and am replicating a database. This is the scenario: Server1 : holds the source database to be replicated (publisher) Server2: is the one that receives the replicated data (suscriptor) Some times it happens that the replication goes down and we do not realis...more >>

Hi everyone, I need you advice. I suddenly found that when click on Databases to expand, "No Items" appear. I could not see a single databases at all( including Northwind, our production databases etc .. I've done a new server registration but still I'm unable to view the databases.. ...more >>

OS: W2k3 Standar Edition, sp1 SQL Server 2000, sp3 our application users brought the process on the database server to peg at 100%. Going thru the sql server manager I found 2 processes that showed the following message sp_cursorclose;1 sp_cursorclose;1 I killed both processes (...more >>

Are there any out of the BOX performance gains going from sql7 to sql2000 ? Thanks ...more >>

Hello, What table can you use to get a list of all of the stored procedures in a database? I need to be able to delete the ones created by users. I am assuming that I will need to use a cursor to step through and delete them. I created one for tables as an example (see below). -- Thank...more >>

Hello, I am trying to delete all of the tables in a database. I wrote the following cursor to step through all of the tables so that I can drop all of the foreign keys if they exist. However, it generates all of the indexes for the table that is selected (I think). I am trying to figure ...more >>

Hi , I am having some issues restoring the following databases i tried to follow the steps in the articles --> http://support.microsoft.com/kb/224071/en-us what i have done : - i am trying to restore all the databases back to the same location after changing to a new disk - Have r...more >>

SQL2K SP4 Im creating a DB that has several Bit coulmns. The data is coming from a mainframe. When one stored proc is run, the result set needs to have a "y", an "n", or a " '' " (space) as thats the way current systems work. Another proc needs to return "Eligible" or "Not eligible". I had...more >>

I'm getting the "Too many backup devices specified for backup or restore; only 64 are allowed" when I try and restore a database backed up on my hosting service SQL Server 2005 to my local SQL Server 2005 Express. Can anyone suggest a way around this ( not involving Enterpise Manager, which I...more >>

Can some one please tell me what these errors mean? I have been looking for weeks to resolve this problem. Win2000 SP4 and SQL2000 SP3, Dual Processor, 4Gig Ram I used the Maintenance module of EM to setup and schedule Backups, Optimizations and Integrity Checks of 63 DBs, and send me a repo...more >>

I have a client who would like to automate the backup. I have used nti backup for cd's and microsofts backup utility that came with windows 2000. They both state that the files cannot be backed up because the files are in use. any Ideas on how to automate the backup???? and bypass the e...more >>

I wanted to know what would be the correct upgrade path from SQL 7 to SQL 2005. Thanks all, SA. ...more >>

Hi, There are two recovery models of SQL Server databases. The "SIMPLE" and "FULL" and also bulked but I am not interested in that. I need a full recovery model as I need to recover the most amount of data and the last full backup from the night before is insufficient. Question: In order...more >>

Hi everyone, Got a question for you. Which would be faster: a. Joining 2 separate tables each with a full text index on the applicable fields or b. Joining 2 separate tables - 1 of which has a FTI on the applicable field and the other table has a non-clustered index on the applicabl...more >>

Can anyone help please, I am using bulk insert for the first time. The statement I am running is: BULK INSERT Titles FROM 'c:\Titles.txt' WITH (FIRSTROW = 3, FIELDTERMINATOR = '\t', ROWTERMINATOR = '\n', KEEPNULLS, FORMATFILE = 'c:\Titles.fmt') ...more >>

Hello; I keep getting this message, 'SQL Enterprise Manager could not add server '(local)' to AD. Error: 14303: Stored procedure 'sp_ActiveDirectory_SCP' failed to access registry key. Now, what does this mean? I am the SA of this instance; I am the dbo, if you will, also. So, I have the su...more >>

How do I write the following Ocacle SQl in MS SQL syntax? I call it an in-line query or correlated subquery Select 1.name name, 1.data table1Data, 2.data. table2Data, 3.data table3Data from (select name, data from table1) 1, (select name, data from table2) 2, (select name, data from tab...more >>

Hi, my SQL server crashed last week with the following error in the Application Event log. Event Type: Error Event Source: MSSQL$CARR Event Category: (2) Event ID: 17052 Date: 26/05/2006 Time: 19:24:23 User: N/A Computer: CARRMAIN Description: Error: 0, Severity: 19, State: 0 SqlD...more >>

I currently have a database through a company that has been upkeeping SQL and storing data. I am cancelling subscription and want to retrieve data. They are sending me a backup DVD with all the files. How easy is it to use Microsoft SQL and can the files be transfered to another program suc...more >>

Hi, I was wondering if anyone had a sql script that can pull the last backup timestamp as displayed when you check database properties in Enterprise manager. Thanks Rusty...more >>

Hello together, is it possible to install different service of luggage (3 and 4) on a SQL server? On the SQL servers are 6 instances furnished. For a SQL server instance is furnished, here a Replikation is to service the luggage 4 to be installed. All further instances are to remain fu...more >>

Does anyone have a script that synchronizes the users and logins in a database after a restore for SQL 2005? I used one for SQL 2000, but the domain groups are not synced, and the SQL users are. So if any one knows how to do this, please post the answer! The script I used that works half is ...more >>

Hi every body, I want to use Full Text Search of SQL Server 2005 to automatically classify my documents; by classifying I mean to give each document a type considering the words it contains. To give a type to a document, I think that one solution is to store the document in the Databa...more >>

Hello everyone, I am configuring the connection pooling for my web application. We are using Sql Server 2000 as backend. I need to specify initial connection poolsize and maximum connectionpoolsize. My question is how many connections can we make simultaneously to SQL server 2000. Exper...more >>

Hi, we have 3 sql server 2000 on W2000 running the same databases on 2 of them a query take 2 or 3 seconds to execute. on 1 it take over 3 minutes to execute exactly the same query. we check all the indexes of the databases , they are ok. It seems not to be a memory problem any idea to ...more >>

Can i have both installed SQL server 7.0 and SQL server 2000 on a windows 2000 server standard edition ...more >>

How do I know which account under which the SQL Server 2000 runs ? ...more >>

SQLServer 2000. I created a login in EM. I want to change the Startup service to SQLServer and SQLServer Agent by this account. So I stopped the both services and use this new account in both services by SQLServer Service Manager. Goto Control Panel - Admin Tools - Services Double click the M...more >>

Do they need to have the same log on account when start up? Control Panel - Admin Tools - Services Double click the MSSQL Sevrer and SQLServerAgent. I can set the account on Log On tab. ...more >>

I just installed the SQL Server 2000 with custom option: Druing the setup, in the screen of Service Account, I use my Windows machine login (this is the login I use when the pc is started up), ie 'Alan' instead of LocalSystem. After installation, I config the Microsoft Search service by using ...more >>

I am under the impression that SQL Server would automatically detect a deadlock and roll back a participating transaction. However, I have had a few cases where automatic resolution did not occur. Instead, I had to go in and manually kill the transaction that is causing a deadlock. Is there...more >>

Good evening everyone I currently had a sql2000 server and I mirrored the box and installed sql2005 on the new server becuase we are moving towards a SAN environment. Before I upgrade the sql2000 I brought the custom built program that our team wrote online and it has a few error dealing wi...more >>

i am using SQL 2000 Server SP4. Error Code as follow Operating system error 123: The filename, directory name, or volume label syntax is incorrect.. Error: 17815, Severity: 18, State: 1 No longer waiting for client connections using Net-Library'SSNETLIB' MSSQLSERVER MNLMAPSCNCAPS01 ...more >>

Which real-time monitoring toll you use for SQLServer ? thanks -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200605/1...more >>

My principal server is a 64-bit cluster virtual server instance on 64-bit Windows Server 2003 Enterprise latest service pack. (I'm on sp1 for Sql Server 2005 as well.) My mirror server is a 64-bit instance as well on the same operating system. They are on different subnet's within the same ...more >>

Experts, Running Windows Server 2003 SP1 with SQL Server 2000 SP4. I have a couple of development teams using databases on the same SQL Server. While they can backup their databases, they cannot restore their own databases. I have noticed that the SQL server role overwrite the DB roles o...more >>

Hello, I would appreciate if someone can give some advice on hardware for building up SQL 2005 cluster. We will have 4 database of 50 GB each. How many processors, memory,... do I need? My preference is to go for HP servers Thanks in advance ...more >>

I've got an SQL 2000 database where some rows were killed by running: dbcc CHECKDB ('theDb', repair_allow_data_loss) The primary key is an auto incrementing integer. I have an older copy of the database, with all the missing rows, located on an SQL 2005 box. I can connect to both databa...more >>

Hi, I want to join 2 count queries toegther and can't work out how to go about it. The first query obtains the total products by country... select count(*) as TotalProducts, c.Country_Name from product_source ps, country c where ps.product_id in (select product_id from record_links whe...more >>

Hi, We need to combine 2 databases as one on SQL Server 2000. One database has wickedly many View tables and the other has more wickedly many Stored Procedures. What would be the best way to combine them. YC ...more >>

DB backup and DB log backup part of DB maint plan still running. I checked the backup folders and it seems like it only missed one db all other db's have both backups. I tried to backup the db and log from query anazyler and it worked fine. When i refresh jobs and check current activity t...more >>

Hi, I am trying to replace every single quote with two "single quotes", prior to sending the dynamic sql string to sql server. ( from a C# application) (in this case I have to send a dynamic string, cannot do parametarized queries) Question is..... Is there any other character that sql se...more >>

Hi, Is it possible to connect two servers in mirror environment (SQL 2005; one is Principal, & other is Mirror) with a SAN? Any help will be highly appreciated. Regards, ...more >>

Hi, Is it possible to connect two servers in mirror environment (SQL 2005; one is Principal, & other is Mirror) with a SAN? Any help will be highly appreciated. Regards, ...more >>

We are in the process of procuring a new IBM SAN for our most business critical SQL database. The database right now runs great on a 10 disk RAID 5 set with TEMPDB and TLOGS on separate RAID1 arrays. As a part of the new hardware implementation, we want to go to RAID10 and as per a vendor reco...more >>

Are there Stored Procedures or tables that will tell me which of the mirrored servers is active ? ...more >>

The agent service runs as "local system" account, and I need to have a specific job run as a domain user. In the properties page for this job step, the only choice I have in the "Run as" combo box is "SQL Agent Service Account". How can have the step run under another account ? tia....more >>

Guys, I just inherit this network. It seems like the previous admin installed MS SQL 7.0 on our SAN. So far the location is S:\Program Files\Microsoft SQL Server with other folders too, ie : S:\Program Files\Microsoft SQL Server\MSSQL\Install S:\Program Files\Microsoft SQL Server\MSSQL\...more >>