It doesn't - please also note that you can't create synonyms for synonyms 🙂 Another thing to be aware of - dropping a database snapshot clears the plan cache. Keeping...

Create synonyms for the objects (i.e. tables, procedures, views) within the snapshot.

CREATE SYNONYM Test FOR SnapShotName.SchemaName.ObjectName

As soon as I finish up the article, I'll update this thread :). In the interim, if you guys want a copy of the procedure, e-mail me at tbollhofer2@gmail.com and...

Another option which is very usefull for reporting (i.e. SSRS, etc.) is to use dynamic SQL to manage the snapshot as a part of your ETL process and link to...

NP 🙂

Download MyODBC available via http://www.mysql.com/products/connector/odbc/%5B/url%5D

select count(*)

from sys.tables

I'm running cumulative update 5, build 3215 (http://support.microsoft.com/kb/943656). You apply the update to the primary node of the cluster. Do not stop the cluster service or any SQL Services prior...

Interesting - will try and reproduce tomorrow. What build are you at? 3186, 3152? Take a look at this article as well, http://msdn2.microsoft.com/en-us/library/ms345128.aspx

You seem to be on the right track - remove any unsed columns from the data flow. Kirk Haselden has a great blog w/ some tips to improve data flow...

Sounds like you have some memory contention 🙂 Try decreasing the DefaultBufferMaxRows. It will slow the package down but should alleviate the symptom.

More info here about how SSIS determines...

In that case -

select substring( replace(replace(replace(replace( convert(varchar,dateadd(dd, datediff(dd,0,getdate()-1), 0),120),' ',''),'-',''),':',''),'.',''), 1, 16 )

Subtract - i.e. getdate()-1

select substring(replace(replace( replace(replace( convert(varchar,dateadd(s,-1,dateadd(d,datediff(d,0,getdate()-1) + 1,0)),121),' ',''),'-',''),':',''),'.',''), 1, 16 )

In that case, launch enterprise manager, right-click on the SQL Server Agent and select properties. Select the job system tab and un-check the box under "Non-SysAdmin job step proxy account"....

The first part enables xp_cmdshell (which is disabled by default)

EXEC sp_configure 'xp_cmdshell', 1

RECONFIGURE

go

Here we are creating a login for testing purposes only

CREATE LOGIN TommyTest WITH PASSWORD = '@dyln1234&'

go

CREATE USER TommyTest...