Hi, the only time i have come across this kind of message was when i ran a DTS package as part of a SQL Agent Job. the package included extracting data from a spreadsheet and populating an SQL table. the package worked fine if i ran it from the designer, it would also run fine if […]
2004-09-06
You might use something like that (part of my logshipping-procedures): /* ---------------------------------------------------------------------------*/ -- Vollbackup.sql -- T-SQL-Script zum Erstellen eines Vollbackups aller Datenbanken eines -- beliebigen Microsoft-SQL-Servers (2000) -- Erstellt am: 3.11.2003 -- Author: Karl Klingler, karl.klingler@dr-stahl.de /* ---------------------------------------------------------------------------*/ CREATE PROCEDURE vollbackup @DestSrv sysname @DestPath sysname AS PRINT '++++++++++ Begin der Vollsicherung vom '+convert(char(22),getdate(),113)+' +++++++++++' -- […]
2004-05-07
2004-03-31
I have a server running SQL Server 2000. There are about 10 databases on this server. The response time of the application using these databases is very slow. How can I troubleshoot within SQL Server to determine which database is causing this problem? How can I tell what stored procedures are being used and how long […]
2004-03-03
1 reads
Thanks. Your're right. I don't like the answer, but it is an answer.
2004-02-16
problem with the code----------------------------------CREATE TABLE [tblTest] ( [YEARVAL] [smallint] NOT NULL CONSTRAINT [DF_tblXXX_YEARVAL] DEFAULT (datepart(year,getdate())), [AUTONUM] [int] IDENTITY (1, 1) NOT NULL , [ValX] [char] (1) NOT NULL , CONSTRAINT [PK_tblTest] PRIMARY KEY CLUSTERED ( [YEARVAL], [AUTONUM] ON [PRIMARY] ) ON [PRIMARY] GO----------------------------------the errorServer: Msg 156, Level 15, State 1, Line 9 […]
2004-02-10
i have a little problemi wont to add this(the new) Column to table thet i use thet have records !!!and i have one IDENTITY Column with AUTONUM
2004-02-10
Hi,If you have Implicit Transactions turned on for your server, or if your application is turning this option on, try turning this off. This will return you to 'autocommit' mode, which will cause a commit each time there is a successful sql statement.-Dan B
2004-02-10
1 reads
Hi everyone, I had posted a message on this board a week or two ago about the same problem. I have a SQL 2000 SP3 running on Win 2000 (with latest SP). Recently, everytime I reboot the computer, one of the databases on this server takes a long time to rollback/forward transactions. It takes more […]
2004-02-10
3 reads
Does this happen everytime? I'd run profiler in the background and see what is actually completing. This runs a number of commands. You can also just run sp_who2 from QA and avoid running this in EM. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones The Best of SQL Server Central.com 2002 - http://qa.sqlservercentral.com/bestof/ www.dkranch.net
2003-12-08
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers