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.

Do you need to hit the data live? If not, it sounds like you should use SSIS to copy the data to SQL Server on a scheduled basis.

sqlcmd does not exist prior to SQL 2005. The predecessor to sqlcmd is osql. Look this up in BOL for usage. It is still available in...