I'm running SBS 2003, which has SQL 2000, using a VB 6 front end. Everything was running on SBS 4.5 w/SQL 7. It was upgraded a couple of months ago. The problem existed even before the upgrade. I'm experiencing a performance slow down after a while, where various queries will time out, wher...more >>

I have an excel spreadsheet that contains a column in the format of mm:ss (37:15) and want to import into SQL 2005. When I do this it gets converted to a date and time (12/30/1899 10:15:00 PM). How do I keep this in just a time format?...more >>

I have a SQL backup job to back up a large database. Then the backup file gets copied to tape by system admin group. Sometimes I got an error trying to run SQL backup: BackupDiskFile::CreateMedia: Backup device 'z:\Backup\DB\xxx_Data.bak' failed to create. Operating system error = 32(The proc...more >>

we have problem with SQL Server 2000 SP3 / Windows 2003 EE we have 10 huge tables, I have a procedure which deletes data from these tables each day. 1. The deletes are very slow, it takes 20 min to delete 400,000 records. It does use index when it deletes, i have seen the plan 2. i am runni...more >>

Hi, MS issued 919341 for W2K3 SP1 working with programs that use Structured Exception Handling (MS SQL is one of them). It has an SQL2000 article 922658 associated with it. This is for build 2187 of SQL2000. Is anyone using the 919341 fix and does it only work with SQL2000 build 2187? ...more >>

Hello again, I also want to truncate some data which is a floating point number. But it is calculated as a result of two other columns. for example lets say column1: 2,4 column2: 4,1483 the result is: 9,95592 but I want to truncate the first 2 digits after the decimal point. like...more >>

Hi, I am new to MS-SQL and I have a problem. Actually I have made similar queries on Oracle, but now I failed on MS Sql. First of all I am using SQL Server 2005, but I think it is not that much important because my question is related something fundamental. I want to compare the result (whi...more >>

I downloaded and successfully installed SQL Server 2000 Desktop edition via "MSDE2000A.exe". Then, thinking I needed "sql2ksp3.exe" to install Enterprise Manager, I attempted to install that. But, I got an error message: "SQL Server 2000 is not installed on this machine. Setup will now exit"...more >>

I am using MS SQL Server 2005 and SQLOLEDB.1 I can't seem get to get my application name to show up for SQL:BatchCompleted messages. It shows up in the SQL:BatchStarting, SQL:StmtStarting and SQL:StmtCompleted events. After the connection string is set, I append ";Application Name=MyApp"....more >>

I am replacing an old NT 4.0 ,SqL 2000 server with a Server 2003 ,SQL 2005 Cluster. We are wanting to do a side by side installation where after everything has been tested we flip the switch in DNS and wins and the apps and dsn's connect to the new server. The problem is that im not sure if i w...more >>

I'm in a sink or swim position. II inherited a database managed by SQL Server Enterprise Manager. I update the database by running jobs which were created quite some time ago. Today, I got the following error message: "The log file for database 'MFGPRO' is full. Back up the transaction log...more >>

I have a primary database which uses Log Shipping to several secondaries. I have setup the primary as a principal in a mirroring configuration as well. When the principal (primary) fails over to the mirror I want the mirror to take on the role as log shipping primary in addition to that of mir...more >>

I have a table in SQL Server that needs to contain "one months" worth of data. This results in quite a large table with approximately 4,882,500 rows (it has 12 columns). I would like to somehow automatically limit the number of rows and am wondering the best way to do this. Running a qu...more >>

I am having quite a bit of problems getting this to work properly. I am on a Windows XP Professional SP2 machine trying to connect to Windows Server 2003. I have Sql Server 2005 installed on the Server machine. I also have a local instance on my developer machine. I can use remote debugging...more >>

Hello, I am currently working on a brand new application and have decided to use Microsoft SQL Server 2005 as the database component. I am certified for Microsoft SQL Server 2000, and in the past have always used the dbo schema for every object. Now that schemas have been separated from the...more >>

Our backups are extremely slow as the docs table in the site database is extremely large. I've tried to shrink the file and shrink the database using DBCC ShrinkDatabase and then DBCC ShrinkFile with no luck. On examining the database i found this... Table_Name data_KB ...more >>

I have been trying to run the following statement and it keeps giving me the error: Column "MissionDetail.TimeCreated" is invalid in the ORDER BY clause because it is not contained in either an aggregate function or the GROUP BY clause. I can't group by or it will return more rows than I ne...more >>

If I open Enterprise Manager 8.0(no login) and create a database and tables inside. Owner of tables is always dbo. I have a different user I want to be an owner of these tables. What should I do? I assume I need to login into Enterprise Manager 8.0 as that user not dbo. But I can't find how t...more >>

Here is my code can anyone tell me what i have done wrong? I am getting an error saying must declare the variable '@TABLENAMES' when they already are. --DECLARE @CUSTOMERNAME VARCHAR(30) --DECLARE VARIBLES - TO STORE SATELLITE DB NAME Declare @vchr_CatalogName varchar(100) --REMOVE AFTER ...more >>

Hi All, I want to Select the MAX of TOP Nth Record and this Value of N should be incremented by 1, I am using WHILE LOOP but getting an error Please let me know what am I doing wrong.. declare @groupNumber as int declare @counter as int SET @counter = 0 WHILE @counter < 100 BEGIN ...more >>

I have a database that has a huge transaction file (auto grow) that I believe is slowing the db down. I backed up the transaction file - what are the other steps to do - truncate and/or shrink the file - 10GB (which it is now) is TOO big - i'd like to make it 1GB maybe. Any help would be g...more >>

We periodically rebuild our indexes when we notice defragmentation of indexes however after rebuilding the indexes we do not recompile the stored procedure. My experience has been that after rebuiling the indexes we ususlly notice a performance gain right away however I was wondering if it is al...more >>

I have a server ser1 which has the sql server running under the security context of the local admin.Whn i try to copy the backup files from this server to a network share it acnnot access the share unless the sever has all authenticated user write permisssions.On setting the auditing on we foun...more >>

I've tried starting SQL from the command line in single user mode (-m). When I try to open Management Studio I receive an error that it can't connect. Can you only restore master from a command line in SQL 2005? Or can I do it from a GUI? Thanks, Mark...more >>

Hi all While reading a textfile using BCP can we specify the column names. The actual situation i am in is i have a number of text files which have to be read into a single table. and all the text files have the first 20 columns in common, the rest is different from file to file. i need onl...more >>

A google search turned up nothing when I searched for this. Is it saying that if my total VARCHARs for all columns in a row add up to more than 8060, then it can't do it? I've never heard of such a limitation before! ALTER TABLE dat_table ADD some_stuff VARCHAR(4000) DEFAULT NULL NULL; Warn...more >>

Hi there, I am trying to use a filename from a vb.net application as a parameter in a stored procedure. However, i don't know exactly how to put the parameter into the stored procedure. I know how to configure the stored procedure with 'normal' parameters, but with a filename as a stored proc...more >>

Hi All, I have a client who last night attempted to install sql 2000 Enterprise Edition SP4. When running the first time through it got past the Password Validation and moved to the Analysing and Preparing stage of the installation. At this point it completely hung - after an hour there was...more >>

Actually, the scenario is we have a web application and each week we need to do data uploads (with etl). During this upload, the users accessing the website should not be able to read data. This is why I want database lock. Now the catch here is, the application access the data using user say...more >>

Hi, How do I lock entire database? I want an exclusive lock on the db by a user who is the dbo of that database only (not sa user). Thanks, Tanmaya ...more >>

Hi, My database is in warm stabd by mode. I need to write an script which make it online, editable, then i will update some value in the table and then it will again put it in the warm stand by mode. What the script for it? ...more >>

keywords: sp_updatestats auto update stats statistics sql server 2000 8.0 8.0.0.760 Windows 2003 SP1 We experience following problems on our SQL-Server 2000 SP3a (SQL Server 8.0.0.760) running on OS Windows 2003 SP1: It doesent seem that the statistics are auto updated on databases wher...more >>

Yes with DTS ...more >>

How do I link/connect other machiner's SQLServer 2000 from my EM? ...more >>