there's also this one: http://tinyurl.com/8bfel
or you can use this free console app I wrote - it's useful for automating script generation since you can launch it from a bat file, etc....
I don't think this kind of history is stored in msdb anywhere.<br /><br />first order of business would be to lock the server down so this doesn't...
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by...
This is a bit self serving perhaps, but I'll post it anyway. [:I] SqlSpec is a shareware app I wrote might help you get up to speed on how all your...
and I just sent you a license. <br /><br />anyone with 6000 quality posts on ssp is an MVP in my book. [<img...
Frank: thanks for the offer to get the word out on this offer. <br /><br />Satya: thanks for doing what Frank offered. [<img...
Just a quick note to let you know that I just started a program to hand out free NFR licenses for SqlSpec to MVPs. If you are an MVP, or even if...
if you really want to generate scripts in an automated way each day, this app I wrote might be useful to you. it will generate scripts for any 2000...
don't know if i am considered old at 36. probably by some, but probably not by Luis! [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]...
the "n" types are for unicode strings. so if you use nchar and friends for all your character data, you'll be fine. www.elsasoft.org
no. our app is a custom inhouse app. we are not running Dynamics GP 9, whatever that is. <img src='/community/emoticons/emotion-5.gif' alt=';)'...
both before and after we were running SQL 2005 ENT SP1. the only change was the hardware. www.elsasoft.org
sql server has no way of knowing what NT user is behind the login unless you are using windows auth. if you want to pass it, you could use something...
duplicate post. please don't cross post. http://sql-server-performance.com/forum/topic.asp?TOPIC_ID=20078 www.elsasoft.org
there can be perf hits for functions used queries. are you planning this? see:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=78601...
I just found out that prod flattened the machine where this was occuring and reinstalled OS and SQL Server and now it doesn't repro. We are chalking...
We are seeing in Activity Monitor and sp_who2 that various update queries (not shown above) are blocked by the select query above. However this...
We are experiencing some strange blocking issues after upgrading some hardware. Here's what's happening: A specific, reltively simple select query...
one of the the most efficient ways to copy large amounts of data is bcp.exe. <br /><br />if you have millions of rows, it will be much faster than...
Separate names with a comma.
