When inserting a record (i.e. in the midst of a transaction) and an error occurs and the transaction is rolled back, will the identity column increment to the next value?...more >>

We are running SQL Server 2000 with SP3. Is there a way to determine the date the last service pack was applied? Thanks...more >>

Hi folks, We are using a Window's written 3rd party payroll product called Meridian here in Australia that uses SQL Server 2000 SP4 (v8.00.20.39). One of the calls is to the extended stored procedure xp_dirtree (which has the xpstar.dll at its heart). This payroll application was working ju...more >>

Hello, All! I'm creating a script to collect DataBase Space used and DataBase space Total and after that I will store this information in a table in my SQL Server. I've tryed using sp_spaceused but I don't know how to use the result of this StoreProcedure. If anyone know how to get this infor...more >>

Have been trying to figure out a reason for a third party program being unable to connect to one of our SQL Server 2005 databases. Here is the situation. Windows 2003 Standard Box. Initially had installed Windows SharePoint and everything worked fine Then installed SQL Server 2005 - inst...more >>

hi all, 1st of all i have to tell that there is NO active directory and NO windows domain! i try to do a backup from a database to a samba-share on linux over network. first i map the samba share with "net use" command to a drive letter. that works, i also can copy file onto it. but if i ...more >>

In SQL 2000, the 'Copy SQL Server Objects' task allows 'copy indexes' under 'Advanced Copy Options' when transferring tables. But I cannot see where the SQL 2005 Import and Export Wizard allows this option. Is there an easy way to do this (I hope) ?...more >>

Is there a graceful best practice to temporarily pause log shipping so that unrelated Windows maintenance can be carried out on the servers?...more >>

I am using sql05 and need to move some tables/data/keys to a new schema (same database). Any easy way to do that? thanks, Chuck...more >>

Hello, Having a strange problem and hoping that someone else has seen this before. Have an up and running SQL Server 2000 (no problems that I can detect). Trying to create a maintenance plan to backup the databases each night. Start the maintenance plan wizard and get to the "Specify Bac...more >>

We currently have a SQL cluster which was built on pirated license keys. This was a managerial mistake let me point out.~ Can we change the license key to legal copy without re-installing SQL? I see that they license key is stored in the registry, but it appears that the Product ID is gen...more >>

Is there a way to see which databases are getting the most activity? TIA - Jeff. ...more >>

I am searching for some reliable-source documentation regarding why SQL Server should be run on a dedicated server. Can anyone provide me with links to such documentation? ...more >>

Hi, all I am trying to do the data differential databackup daily and full backup during the weekend. Log shipping remain the same as usual. There is anything that I should be aware of before I chnage the backup method. It takes too long to have full data backup every night. Thanks, ...more >>

Hi group, I am seeing degraded performance after applying SP4 on SQL 2000. My specific queries (they are in stored proc) access linked server. When the process is run, I keep seeing blocks on the linked server side among processes of the same spid spun off from the calling process like this...more >>

I am a PhD student at UIC and I am stuyding the performance of TPC-C benchmark over SQL Server. I would appreciate if someone could tell me how I could obtain the TPC-C benchmark application from Mircosoft? Thanks. Talha ...more >>

hello, i have a problem, we are made test of stress over an application and the tempdb grow up to 800mb in les than 5 min. exists a form that i can identify what stored procedure make that this occurs? thanks ...more >>

My app needs to be installed in 3 locations A,B and C. All three locations will use either MSDE or SSQL and have Broadband Internet with static IPs. I want to design the app so user will be able to search and update database in three locations from either location (A,B or C). My problem is how t...more >>

Hi, We have SQL Server whose data is being accessed through crystal reports and excel spreadsheets (using ODBC driver). I am trying to find all the crsytal reports ad excel spreadsheets that are hitting a particular database. I thought SQL Profiler will help me with that. It did to some exten...more >>

I have just upgraded my SQL Server 2000 to SQL Server 2005 and from what I understand the upgrade will do the database conversions for you. After the install I tried to delete a row from my Item table which is a foreign key to about 10 other tables. A simple Delete Item Where ItemID = 888 ...more >>

Hi All, Following error message is displayed whenever i open the Sql Server Management Studio Database 'msdb' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information. (.Net SqlClient Data Provider) I am using Sql Server 2005 wi...more >>

I am trying to decide if we should use Microsoft Backup (Database Maintenance Plans) or use Veritas. We already own Veritas, and the SQL clients. Option 1. Do Not use Veritas SQL client. Use Microsoft Backup to produce a ..BAK file on the SAN. Use the Network install of Veritas (not on SQL sv...more >>

I have posted the following in the 'SQL Server Programming' discussion group; not sure if it belongs there... so I'm reposting it in this group as well: I have a 540 million row table; in it, there is a column whose datatype that I am attempting to alter using the following command: alter ...more >>

All How do I go about setting up a linked server between a SQL Server 2000 instance in Domain1 to a SQL Server 2000 instance in Domain2. There is a trust between the two domains and when I log onto the server in Domain1 I can connect to the server in Domain2. Any assistance would be app...more >>

We use SQL server 2000 sp3 database server in Windows 2000 Advanced server OS. In production environment, one of the fact tables in our datamart has over 150 mil rows. A indexed view is built upon this fact table for reporting purposes. The problem is that when queried for the same criteri...more >>

Hello, Does anybody know the process of identifying databases what are not used? This can really help me since in our environment we have numerous databases. Thanks, Gary...more >>

Hello All, I have a cluster of two nodes running Windows 2003 Enterprise Edition with SQL Server 2000 Enterprise. Each node has 32 GB. And I set the max server memory and min server memory to 28 GB, but the maximum memory was shown only 16 GB, and SQL Server reports "unable to allocation m...more >>

Hi, When I tried to restore a database backup that was created by SQL Server 2000 / SP3a installation into a SQL Server 2000 / SP4, I got the following error message - --------------------------- Microsoft SQL-DMO (ODBC SQLState: 42000) --------------------------- The file on device 'D:...more >>

Hi, I need to get information from a backup file. For example the logical name of database file (data/log) that exist in the backup set. I know that RESTORE FILELISTONLY and RESTORE HEADERONLY provide this information, but I need to get them in variables, or something that makes me able to u...more >>

My SQL server log is flooded with "Login Failed" messages. SQL profiler trace shows application name = "Microsoft SQL Server". What are these connections? Why would a SQL Server initiate connections to another server? Urgent - please help! Audit issue! thanks in advance....more >>

Dear All, I am new into database.Can you please help me in getting my queries solved.I am currently learning oracle basic and looking more into SQL. Can you please telll what is the difference between oracle and sql.Both are database but what are the differences between them. Please support m...more >>

I am using html, vbscript, asp and sql server. The website is mainly in Russian but may have some English. The consensus appears to be that it is best to use utf-8, so I plan to use html charset utf-8, asp codepage 65001 and ntext, nchar and nvarchar character types. If the above is cor...more >>

Hi, When I want to restore my database, there might be some users browsing the web site and therefore they have connection to SQL Server. I need a quick way to kill all of users and perform the restoration. I think I must use KILL command but instead of writing an script and a cursor, I thoug...more >>

Hi We have a mission critical database above which we have a crm application that sits on top of it. In trying to improve the performance of the sql database I have added another logical disk which is in actual fact another raid 1 array. I would like to move the transaction log files to thi...more >>