1) Is the server set for mixed mode security (if not, sa won't work)

2) When you logged on to the server, are you able to talk to a DC (domain...

There's always the option of using a public Microsoft NetMeeting server and putting a meeting password on.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

True, but most every T-SQL command would be expected to run wherever the "server" resides.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

I know some like the idea of returning a value via an OUTPUT parameter, but I'm rather on the same side as Andy. If you're using RAISERROR and trapping in...

Yes, the Books Online has been updated. The link is available from the SP 3 main page.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

Take a look at SQLCompare from Red Gate Software.

http://www.red-gate.com/

If you need to compare data, look at SQLDataCompare. The enterprise license for both products isn't terribly expensive, especially considering the price...

You have to either:

a) use xp_cmdshell

b) schedule a SQL Server job with a CmdExec step.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

Revoking public role predominantly prevents investigation by users who have already passed the first layer, authentication. In other words, they already have valid access to SQL Server.

K. Brian Kelley

http://www.truthsolutions.com/

Author:...

Microsoft is aware of the issue and to be perfectly honest, security has often been thought of in hindsight. This isn't just true of Microsoft products, but the whole gamut....

In the migration between NT 4.0 and AD, is this an in-place upgrade or side-by-side?

Remember that the user owns a database object and while it may appear as "MyDomain\MyUser" that...

How recent was your last backup?

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

Look at the system stored procedures:

• sp_add_job
• sp_add_jobstep
• sp_add_jobschedule

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

Netmeeting? Thereby whoever is "hosting" can also demonstrate and share apps to show what's going on...

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

If the possibility of the question not being asked or an answer not being given exists, you have at least 3 possibilities. Anything based on base 2 will thereby fail....

There are security solutions such as Protegrity, that'll secure the data. However, I don't know if these solutions obscures the information you can get from Profiler.

As for keeping sysadmins out,...