Viewing 15 posts - 166 through 180 (of 294 total)
This is possible but you will need to supply more information if you need help with this. What are you trying to do?
September 8, 2008 at 5:54 am
If you add an alert for Insufficent resources it would fire when it encounters a disk space issue. There is a script attached to an article I wrote on this...
September 4, 2008 at 2:15 pm
Have you looked in the log for the job to see what error you are getting?
September 4, 2008 at 10:40 am
Can you post your code, and details of the error message?
September 3, 2008 at 10:10 am
I didn't mean to wink I just meant to close the brackets!!!!
September 3, 2008 at 9:17 am
Try something like this...
DECLARE @FileName VARCHAR(150)
SET @FileName = 'C:\file.xml'
CREATE TABLE #XmlImport
(
...
September 3, 2008 at 9:16 am
Do the files have to be CSV? as this might be easier if they were XML.
August 27, 2008 at 11:40 am
You could look at rolling partitions to move out months/years of data in one go.
August 26, 2008 at 11:44 am
If in doubt set the owner of the job as SA this will now run the job as the account that runs SQL Server, and provided this has not been...
August 26, 2008 at 9:37 am
Read the Log Shipping overview in books on line.
August 26, 2008 at 6:06 am
In one organization I worked at we compared ERwin with Sybases Power designer. Power Designer won hands down for useability...
The are both database design tools ideally for doing database...
August 21, 2008 at 9:05 am
See article on this site:-
http://www.sqlservercentral.com/articles/Administration/3177/
August 11, 2008 at 4:06 am
If you add DDL triggers you can record events like this and hopefully capture what happened.
July 26, 2008 at 10:20 am
If you mirrored the original database you can take a snapshot of the mirrored copy if you want a read only copy for reporting purposes.
July 25, 2008 at 1:02 am
See http://www.simple-talk.com/sql/sql-server-2005/sql-server-2005-ddl-trigger-workbench/ for a good explanation and example of how to implement.
July 24, 2008 at 11:41 am
Viewing 15 posts - 166 through 180 (of 294 total)