RE: DTS Scheduling after input is available!!
He is a good article on this subject.http://:www.databasejournal.com/features/mssql/article.php/3319261
2004-08-10
data
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
need to concatenate columns
I have a column that is varchar (255) and need to change it to text. That's the easy part. The column is in a table that contains a sequence number that tracks the number of rows because the column must be concatanated together for display. The original database was version 6.5 that did not have […]
2004-06-23
1 reads
RE: Question of the Day for 17 Jun 2004
Technically speaking, you're right Brent. And the 50+% of people who chose the "correct" answer are wrong (oops, that includes me :crazy.I think we tend to overlook 64-bit. But then again, so does Microsoft.
2004-06-17
RE: Restoring SQL Server without having the Data files?
Have a look in book online at article "Restoring the master Database from a Current Backup". I think it will answer your question
2004-06-15
Replication Setup
I am trying to setup a test transactional replication between serverA (publisher and distributor) and serverB (subscriber) on the Pub database. The setup complete successfully. However, when I insert a record in serverA, I get the following error in the Distribution Agent History and server B is NOT updated:...Could not find stored procedure 'sp_MSins_authors'.Please let me […]
2004-05-27
RE: "sqlmaint.exe failed" when using xp_Sqlmaint
Right-click on the maintenance plan and select "Maintenance Plan History". This is where you'll find much more descriptive error messages.
2004-05-05
RE: SQLServer 2000 and MSAccess 2000.
Timberwood,We are currently using the MSAccess / SQL Server configuration that you are using. We have approximately 330 users with about 30 users connected at one time. These Access dbs were created in '99 and use a combination of DAO (run queries against the linked tables) and ADO to exec Stored Procedures against SQL Server. […]
2004-05-03
RE: Question On Group By
UNION probably works have not tested it, but other option would be to build a temp table with dates to join against or perform sub-query within.
2004-04-13
RE: EM Task Pad Table Info -- Specified Table Not Found
Sure you can! Take a look at sp_spaceused in BOL. I would also search the script section here. This will surely return several useful hits.
2004-04-08
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