You're welcome 🙂

What is the exact error message?

You should enable the RPC on the lindek server. Right click on the linked server and go Server Options. Also you should enable the RPC...

If you mean a seperate mdf or ndf for each sp or whatever its technically possible but not logical. Another case for every object in the database you can make...

You cannot directly join the xml data type. in BOL start with .value of xml type. Namely XPath.

Zubeyir

I'm not sure if I figered the problem out correctly. Two questions I may ask:

* Is the SQL service account able to connect to MS Exchange? (in this...

select your query in Management Studio in a query window. Right click and select "Analyse Query in Database Tuning Advisor" then enter the same credentials when you prompted that you...

Make a loop through

SELECT [name] master.dbo.sysdatabases

There the sp dbo.kill_all comes...

We use a custom kill procedure killx

This procedure first gets DBCC INPUTBUFFER of the spid that you are going to kill. Additionally the...

Hi Andy, please use the public link for your blog since we don't know your admin password

http://blogs.sqlservercentral.com/admin/blogs/postlist.aspx?App=andy_warren

instead

http://blogs.sqlservercentral.com/blogs/andy_warren/default.aspx

Cheers

Zubeyir

Quite excellent and reporting services is a good idea. But we sometimes need just need to know more than the free space in db files. In these cases I personally...

Check the account that you are using by looking the lower right corner. In the SQL Management Studio under the security/logins/<login_name>/User Mapping path you may give the permision to access...

But it is not about being a leader, it about being somebody to decide the future architecture of a system. The leader then will lead the team to build that future.

Great article!

After spending a lot of years being a DBA then the next best thing must be a DBAA position. But I've never seen a text explaining it this clear!...

Thanks for the reply Yelena.

This account is not added to SQL Server, and it hasn't to be. This is just an SMTP account to reach the exchange server in the same domain. It...