DTSRunUI isn't redistributable, but of course, DTSRun is. You could script DTSRun in a VBScript. It is also possible to add a couple of stored procedures to the database to run DTS packages from osql/isqlw. I found the code via google, but of course it's on my work computer... try looking for "dts stored procedure […]
2004-07-10
What is the purpose of "STANDBY Mode"? If it is merely the read only aspect of that, then couldn't you usesp_dboption to set the read only mode of a database to true?ie exec sp_dboption [dbname], 'read only', 'true' and then exec sp_dboption [dbname], 'read only', 'false' to resume normal operation
2004-05-27
There is an article on this at 15 Seconds (http://www.15seconds.com/Issue/010308.htm) that will explain it fairly well (it was written for SQL 7 but this should work for 2000 as well). The main point with paging using an SP involves dumping the desired data into a temp table with the first col being an identity (pk) […]
2004-03-18
I agree that No is the answer to your question, however I wanted to see if anyone could give me a clue as to why a Delete tablenameworks and a Truncate tablenamedoes not. It give me the error that a FK error exists, but gives no ref to the FK and I was unable to […]
2004-03-04
was set to 0 tried as high as 999 no effect. We did find something interesting today... If the query is executed in QA it takes 1.44 minutes to execute the first time but it does run. subsequently the query works in EM (instantly) and also instantly in QA.Kelley
2004-02-26
2004-02-26
How long does the peak last? Not uncommon on any box to hit max cpu for a second or two at a time, it's sustained max that hurts. To track it down, it depends on the culprit. If it's a query or job, running a server side trace would help you identify it. If it's […]
2004-01-09
Hi Andy,That works perfectly now. My only concern now is that it's taken me ~ 5 minutes to get to writing this reply, as when the 'posting' page loads, it's getting stuck on loading some object (not sure what). i.e. I still have a page sitting here saying (in status bar) "(1 item remaining) Opening page […]
2004-01-04
1 reads
quote: There is also a script here that can help http://qa.sqlservercentral.com/scripts/contributions/26.asp Steve, I use SQL Server 2000, and that code doesn't work. For example, dbcc loginfo returns CreateLSN, which is a large integer such as 115000000048700025, not a datetime value. I changed the type to varchar(25). Executing it, the same values are always returned regardless […]
2003-12-09
2 reads
qod.asp doesn't fit on the screen. You have to scroll horizontically. I'm not sure if it was this way before. Frank http://www.insidesql.de http://www.familienzirkus.de
2003-11-25
1 reads
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