It'll use the connection as you defined it in the linked server configuration.

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

Analysis Services, while having the SQL Server name, is really a separate product. Keep in mind that the supporting database is in MS Access, though you can switch it to...

You know, I saw the same thing when I upgraded to build 635 and I couldn't trace it to anything specifically, but I was connecting to SQL Server. I didn't...

This is true, but remember that stored procedure creation puts entries into the system tables. It does not compile the stored procedure.

I think SQL Server allows this in case you...

What version of Perl are you using? ActiveState or compiled yourself?

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

1) First step is to understand what the certifications are and how you achieve them:

http://www.microsoft.com/traincert/default.asp

2) Determine what certification you want to attack first and specifically what exam you want to...

Keep in mind that if you give the user db_ddladmin and the user creates the object belonging to dbo, the user won't be able to assign permissions (you didn't say...

We do something similar to what Antares recommends. One addition is to also exclude pagefile.sys (Windows page file). This is usually found in the root of the system drive (typically...

quote:

---

would revoking his rights to the tables still enable him to write to a table via a sproc (which is ok with...

If you know the groups and the # of records to sum for each group, the easiest way that comes to mind is with a UNION (actually a UNION ALL...

I know this is standard boilerplate, but remember that such changes are not supported by Microsoft. Should they encounter an issue when you place a support call, they might ask...

Could be scanning. Could also be one of the two SQL worms related to the blank sa password issue roaming around. The port from the client is dynamically assigned by...

It's a buffer overflow error in a function within NTDLL.DLL. Something probably got patched in SP2 and carried forth from there.

MS 03-007 covers the vulnerability, but only points to IIS...

No. Only SQL Server 2000 versions are affected.

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

Technically, though, even when going through EM it changes the registry key.

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