RE: DBA
Try using the DTS export wizard. Select the "Copy objects and data between SQL Server databases". In Advanced Copy Options, you can check "Copy database users and database roles" and "Copy SQL server logins".Greg
2004-08-31
maintenance
Performance Alert
Folks, i want an alert to be displayed by SQL when the processor shoots above 80% constantly for 30 seconds. Is there any perfomance counter alert sepcifically for this purpose? Performance monitor can be set to alert for the counter; but i couldn't find an option how to setup the alert if the counter is […]
2004-08-06
Current Activity
Is there a script that I can use that will show me all the users currently showing activity on any given database. I'd like to find another way rather than looking in the Process Info.Shane
2004-07-12
1 reads
RE: sp_executesql in DB2 - please
http://www.lazydba.com hosts a DB2 mailing list. You might want to post there.
2004-06-22
How can the tempdb transaction log be full?
When trying to export data from a table to a flat text file, I am suddenly encountering a failure, with the error message stating that the transaction log of tempdb is full and it needs to be backed up.I'm using the DTS wizard to create the export, the data is being pulled from one table, […]
2004-06-17
2 reads
RE: A Quick question.
In your view change the select for the column you want changed to cast( <column> as datetime)
2004-05-25
Giving permission for a user to run a pkg
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-04-12
RE: Cross tab
David,Let me explain my problem hereCREATE TABLE TEMP (ID INT, stdate DATETIME, CODE CHAR(10))INSERT INTO TEMP VALUES(1,'2004-04-01','TEST1') INSERT INTO TEMP VALUES(2,'2004-04-02','TEST1') INSERT INTO TEMP VALUES(3,'2004-04-03','TEST1') INSERT INTO TEMP VALUES(4,'2004-04-01','TEST2') INSERT INTO TEMP VALUES(5,'2004-04-02','TEST2') INSERT INTO TEMP VALUES(6,'2004-04-03','TEST2') INSERT INTO TEMP VALUES(7,'2004-04-01','TEST3') INSERT INTO TEMP VALUES(8,'2004-04-02','TEST3') INSERT INTO TEMP VALUES(9,'2004-04-03','TEST3') INSERT INTO TEMP VALUES(10,'2004-04-01','TEST4') INSERT INTO […]
2004-04-07
RE: SQL Profiler
And here are a couple more: http://qa.sqlservercentral.com/scripts/contributions/407.asphttp://support.microsoft.com/default.aspx?scid=kb;en-us;271509
2004-04-01
RE: WScript in vbscript activex task
Try taking advantage of SQL jobs.We did the same you are trying to do like this.Set up a Job with say 2 steps.Step 1 searches for that file, if it is found goto step 2, otherwise try again in 5 minutes.Step 2 Do what ever you need to with the file. There are some more advanced […]
2004-02-23
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers