THere is an option when creating a SQL Server Agent Schedule to have a job run whenever SQL Server Agent starts. This seems like what you want.

Of course the OP doesn't mention if he is using datetime or smalldatetime. So if smalldatetime the seconds are fine. Most of the apps I have worked with...

I wouldn't waste my time with notification services as it has been removed in SQL 2008. I know that most places that offered Notification Services Training are discontinuing the...

If you are deleting ALL the data from the table who cares about the statistics. They will be meaningless until new data is inserted and the stats get updated....

I dealt with a similar issue last fall and had to recreate the msdb database. There were no backups, I was not aware of the SQL Server, so I...

Shouldn't the Clustered index size match the table size since the clustered index is the data at the leaf level?

I like to use between when doing date ranges, I just think it is easier to read. I would use DateAdd(SS, -1, DateAdd(YY, 1, Convert(datetime, @year))) to set my...

Is the routine in a DLL or does he just want you to copy code into SSIS?

Parsing a text file is a piece of cake in SSIS. ...

You would need to setup 2 variables. 1 for the connection string and 1 for the client.

You could use a variable as your sql command, but you still need to set the variable. How do you know what you want the query to be?

The error is saying that you are not allocating enough space in the DT_STR column "Copy of Copy of". Expand the length of the string. I would also...

Hey Brandie, unfortunately I think you have to go with a sort transform before the merge transform in this case.

I think you can only narrow down by looking at who is in the sysadmin and securityadmin roles as they are the only ones who can create logins.

For the future...

What is the error you are getting?

I am guessing that Outlook is not installed on the server so you do not have the CDO library available.

I have read 64K since SQL Server stores data in extents that consist of 8 8K pages.