With my maintenance plans for backup jobs, I can control how long the backup files will remain, days, weeks, months, before deletion. With my differential backup jobs, I do not seem to have the ability to control the residency of a differential backup file to disk, at least I am not aware ...more >>

Hi, I have a serious deadlock problem. I'm using the Profiler with Lock:Deadlock, Lock:Deadlock Chain, TSQL:Batch Completed and TSQL:STMT Completed event classes. Im the very load circunstances, the CPU goes to 100% and SQL Compilations/sec are over 300 ... In the situation I cannot see ...more >>

Hello, Just wondering if the default Isolation Level can be changed for an entire database (or server) instead of having to issue a 'SET ISOLATION LEVEL....' for a connection. Many thanks, Syd....more >>

I want to monitor 2 stored procs using Profiler. I want to know the number of times they are called, the date/time they are called and the amount of time they take to execute. I also want to keep the Profiler records to a minimum. What is the best way to get this information? In "Filters...more >>

I have this insert statement: INSERT INTO dbo.TinNormalized (TIN, PState, PCity, PName1, PAddr) SELECT DISTINCT Case WHEN TIN = NULL THEN 'Dummy' END, Case When PSTATE = NULL Then 'Dummy' END, Case When PCITY = Null Then 'Dummy' END, PNAME1, PADDR FROM dbo...more >>

I am new to working with SQL Server, though I have experience with Oracle and other database systems. I need to get some introductory training in SQL Server database administration and am planning to take one of the standard MS offerings (either 2072 or 2723). Question: I will probably ...more >>

I am setting up about 60 or so DTS packages to run every night. These packages will be recreating all the tables from a foreign database. At the moment, I have them dropping the tables, creating the tables, copying all the data to the new table and creating the keys. Would it be better to...more >>

Hi, We are just in the process of looking at perhaps setting up SQL server. Before I get deep into it I have some basic questions and would really appreciate it someone could answer. Basically a small office. We can purchase an upgrade of our existing accounting software that uses MS SQL. B...more >>

I need to rename a login that owns some tables. I cannot do this via the enterprise manager? Can I do it via SQL scripting? Please advise (also if there is a better NG to post this to) Thanks ...more >>

Hi all, I've got a customer that is creating a LOCAL PACKAGE/SQL AGENT Job to run a TextImport.exe program on the server, which loads a table and creates a log file. They want to be able to print the log file - to a network printer, as the final step. I do not see PRINT type tasks in the d...more >>

Hi!!! which permissions are necessary to execute xp_cmdshell? ----->without being SA Error: Msg 50001, Level 1, State 50001 xpsql.cpp: Error 87 from GetProxyAccount on line 604 tanks!!! ...more >>

background info: sql2k on nt5 I have a database backup job created by maintenance plan. so the backup file looks like MyDatabase_20040430.bak the job was run nightly so the suffix of the backup file changes daily ( to 20040501, 20040502 and so on) my question is, i have another scheduled t...more >>

Im trying to shrink a data file with 5 gigs free. Nobody is in the db but Im 40 minutes down the road with not light at the end of the tunnel. Is there a faster way? ...more >>

Hi all...We're planning to buy a brand new SQL server. Any recommendable brand, configs, etc. in market today? Quick response appreciated thanks in advance RE...more >>

Is there any software available (preferably freeware but commercial an option) to help me create a data dictionary for my database to help document it? Thanks ...more >>

I am looking for information on running SQL Server 2000 with Windows 2000 Terminal Server. I have 10 -15 users who will use an application with SQL 2k as the backend connected through Windows 2k Terminal Server. All of this will be running on one server with dual 2.06 Ghz CPUs and 4 Gigs R...more >>

Hi all, Is there a way to make SQL Server 2000 log every SQL query sent to it? -Oleg. ...more >>

Hi, Can I specify "read only" to one of the member of Domain admin? how to do that? Thanks... ...more >>

I have a 225Gb SQL 7 database on an NT 4 server that I need to restore to a Win2k Server running SQL 2000. Is it possible to restore a SQL 7 database onto a SQL 2000 server? Gav ...more >>

Thank Brad, for you for your reply. And yes please - I really could do with some help to script a stored procedure as well as a trigger as outlined in (1) and (2) below: As per your suggestion, I spent all night thinking about this and I have come up with the database structure here and a descrip...more >>

Hi, We are using a new third party application that has SQL Server 2000 as the database. It is an ASP page front end and uses ODBC to connect. There are about 20 people who use it during the day. When I look in EM at the processes there are well over 100. Even in the morning after everyone h...more >>

Is there a Microsoft recommendation for how many databases that can exist on a SQL Server 2000 (std ed) server (Windows 2000 4 CPU, 4GB RAM)? What formulas/calculations can be made to determine the capacity (# of db's w/o affecting performance/resources) for a given server?...more >>

I am looking for some links or hints on how to get started creating an SQL knowledge base that eventually I can write a .net desktop application to interface with the database. But what I am looking for is some info on getting started...ie the types of tables I should have in the Database...more >>

Hi I have this problem every time i try to open sql server enterprise manager i get this error SQL-DMO has not been registerd please contact your system admin I tried to run REGSVR32 to registerd the SQLDMO.DLL but it's telling me LoadLibrary failed (c:\program...)failed I also tried http://sql...more >>

Hi I have a couple of named instances of SQL Server 2000 on one server, and everytime when I try to register the server in Enterprise Manager from another SQL server, only the default instance is showed up, how could I register a named instance of SQL Server 2000 in enterprise manager on other ser...more >>

Hi I recognise that long varchars are cut when exported to the text file. This is the scenario Define varchar(6000) in the test table. Put in one line with , for example, 600 chars Run import data to the text file. The length of the string in the text file is only 232 chars Any idea Thanks ...more >>

I have a set up DTS packages that I have set up to run every night. Each package copys a table from a foreign database to our SQL Server 2000 system. There are about 60 packages and some of the files have over half a million records and take a little time. I have a package that calls all ...more >>

Hi, I'm getting "BackupMedium::ReportIoError: write failure on backup device 'd:\select legal\MSSQL$LEGAL\BACKUP\legal_db_200404292100.BAK'. Operating system error 112(error not found)" messages in the SQL 2000 Server logs when we try to backup our databases. This is followed by "Internal...more >>

Hello i try to migrate from MySQL to MSSQL i have a query lik SELECT [...] FIND_IN_SET(id, "1,53,82,102,435") [... but MSSQL don't know the string function "FIND_IN_SET" My question is now is there a FIND_IN_SET-like function for MSSQL for those who not know what FIND_IN_SET do FIND_IN...more >>

When I am trying to restore a database, getting an error message which says "database attempting to restore was backed up under different sort order id than the one currently running and atleast one of them is a non-binary sort order. Operation terminating abnormally." How I can I rectify ...more >>

Hi All Can anybody tell me why Memory is not utilized by MSSQL Service. The Environment as follows.. It is an Critical Web based Application with SQL 2000 Standard Edition + SP3 as backend OS: Win 2000 Advanced Server + 3GB Memory + 2 CP MSSQL Memory Configured as Dynamic with Maximum Memory...more >>

I am migrting database from Sql Server 7 to SQL Server 2000. When i try to attach database in sql server 2000 it's giving error like "Difference in sort order id 51 and 52 collations differece from server. please help me...more >>

I am pretty new to SQL Server programming [as I normally do every thing in the client app] - but I have a problem that is better handled on the server - and I would sure appreciate some advise on how I should design it and start me off: I want to schedule some direct debit transactions to occu...more >>

I am using SqlServer 2000 and I have problem with the restore from a backup set so I try RESTORE HEADERONLY This returns a row with Null to all fields and ** INCOMPLETE ** at the BackupName field Is this a corrupt backup file or backup file from previews version of Sql Server ? Nik ...more >>

Hi, When i try to transfer data from a sql server 7 database to another sql server 7 database i get the following error. different sort order id. Has anyone ever come across this. Do help - Urgent. TIA, Arun...more >>

I try to identify the value of increment property of a column. INFORMATION_SCHEMA does not suppply it. Somebody know how to get it ? Thanks ...more >>

Hi I have IIS from XP Pro and am wondering where I can get MSSQL running on IIS? Any pointers? Cheers, Jules ...more >>

We're currently configuring a new Windows 2000 Server with SQL Server 2000 standard (also running Terminal Services, if that matters) and we're seeing the following error a lot in the log files of some third party software (a Win32 service running as localhost), and in our PHP scripts (running as...more >>

I have a database with millions of records, and a SP that grabs about 5000 records at a time. The same SP is executed each time but it can not select the same 5000 records. This is what I did. Create a table with an ID which holds all the records that have been grabbed. Then I grab the re...more >>

I'd like to move the backup devices from the current location to the new drive. Is there a way to edit the path to point to the new location ? I don't want to recreate all the devices. ...more >>

My SQL Server suddenly won't start. The message says "SQL Server can't start DUE TO LOGON FAILURE". Why this kind of thing happened, and what does the SQL Server mean by Logon Failure and how to solve it? Please help me......more >>

Hi I have to explain the problem with an exampl TableA Table Id Amount id Amount 1 10 4 2 5 3 7 I want to join the tables on Amount. But I want to use eac...more >>

We had disk failures and SQL Server won't come back up because the master DB is corrupt. Is there any recovery method other than re-installing SQL Server nad then recovering the application databases...more >>

I've inherited a database where auto create stats and auto update stats have been turned off. there is a job that runs once a week that runs update statistics on each table with the norecompute clause. In watching profiler I'm seeing quite a few missing statistics. When does it make sense to t...more >>

I have an issue where a particular function runs wicked slow on SQL 7 SP4, but runs just fine with SQL7 SP1. Are there any hotfixes or patches that should be applied post SP4 that MIGHT help with this issue? Thanks in advance for information. Brandon Vogel Network & Systems Manager Ac...more >>

Hi Is there a way to checkin and check out database changes into visual source safe. I don't need to include the records (if possible, lookup tables should be included). My main concern is to track changes in the database model changes and the stored procedures and user defined functions Right n...more >>

Is there a way in SQL Server 20000 to script out a DB maintenance ? I have a instance that has about 100 databases on it. I like to created individual DB Maintenance plans for each Database. Is there a way to script out a plan and possible run it as a batch file to create many DB plans at once? T...more >>

Hi, How Can I list the users in an NT group, ie I have user Joe Bloggs who is in NT Group Domain/Users. I need to return to a client app what group they are in. Julian ...more >>

Hi every one, I have a trigger (for update) on a table that start a stored procedure. Is there a way that the update get done before the SP finish. In other words, Do the update even if the SP is not finished. that's because the SP may be long but i don't want the update to wai...more >>

Hi Can you install SQL 7 on a windows 2003 serve thanks...more >>