I forgot, you must then add @filecount options to sp_trace_create in script generated by Profiler,

explanation and examples here: http://www.sqlservercentral.com/articles/SQL+Trace/71841/

http://msdn.microsoft.com/en-us/library/ms190362.aspx

When you choose "save to file" in profiler you have options "Enable file rollover" and "Set maximum file size", set them for your needs, set any additional parameters, choose only...

If stats are accurate, then most probably you encounter problem with http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/[/url]

select @@SERVERNAME ,value from master.sys.configurations where name = 'max server memory (MB)'

And what is not clear in this error message? You must check link and account that is used by this ssis package, maybe someone changed configuration of network, account...

There is no good or bad backup strategy, if it meet yours company RTO (recovery time objective) and RPO (recovery point objective) then it is good. But why you truncate...

Why do you want to do this?

You can't because of eg. limitations of internal structures of DB

Try sqlcmd -S .\Offline -U sa -P 123abc456

in windows environment, mostly you use backslash \ not slash /

1. Yes

2. Yes

It only depend of your needs

Details you can find here: http://msdn.microsoft.com/en-us/library/ee210714%28SQL.105%29.aspx

"The database version number for 2008 RTM and SP1 is 655." so you have to install proper version of SQL 2008, RTM or SP1

http://sqlskills.com/BLOGS/PAUL/post/SQL-Server-2008-R2-bumps-the-database-version.aspx

Have you read?...

Why on sa? If your group or user don't have acces to SQL via Windows Authentication on sysadmin rights, and you don't know which group/user have this privilages, then you...

tommyh (10/17/2012)

---

Now let me just first say that i dont have a clue what im talking about here.

But why not modifiy the app to go against a host of...

One of windows administrator do that 😉

No SQL Server like other windows programs don't log this kind of events, but many useful information you will find in Windows Event Log.

GilaMonster probably has right. To check what is happening, run SQL Trace with destination to file on sql server, this quarante that 100% events will be captured, and you will...