SELECT @Table_Name = '''' + MIN(Table_Name) + '''' FROM DB_Table_Names

Copy osql.exe to their machine.

It will grow alot!

Not sure how to estimate this. Are you updating one field or many? At the least, it will have the...

By default, if someone has quest access to msdb, they can create a package. It basically requires insert to sysdtspackages in msdb.

Glad you figured it out and it's working.

Thanks for the followup.

I believe profiler is lossy, so if performance of the server becomes an issue, it will drop events.

If the server is overloaded, you might get this a lot. I'd reduce...

Using the with move is only in restoring the database. You wouldn't use this with the log.

when restoring the log, the database must have been restored with the "norecovery" or...

I agree with lots of what Andy wrote, but I'll chime in as well.

SQLInjection will become one of our biggest worries going forward. With so many bugs and patches coming...

Thanks for the link catch. It's fixed.

You can use either with the IIS server connecting to the SQL Server. Not sure about the actual end user, but I suppose if they connect to IIS using Windows...

do you mean dbcc indexdefrag? Access can grab a large number of locks and I suspect, block the index defrag from running. DBCC inputbuffer returns the last sql batch (or...

Pls don't cross post. Answered in the other thread.

I always use aliases. You learn the pretty quick and as long as you are consistent, it's easy for your team to read. If the Products table is always...

Finally one question that people like

Haven't run through it all, but I wouldn't depend on the dbid. I'd use the names you want to exclude. I might also insert the results into some log...