Although this is a very good article with regards to moving user databases, what happens if you want to move the master database somewhere else? This is something I...

The Browser is the most convenient way to connect to each of the servers. Using the "Connect to" dialog box enables our developers and testers to connect to instances...

Hi!

Thanks for the prompt answer.

I forgot to mention that! The SQL Server Browser is active on both ends. Does the browser not use 1433 for the default instance...

Hi there!

Thank you very much! That was exactly what I was looking for!

Kind regards,

Kev:w00t:

Hi,

would this not be the perfect opportunity to partition your database. Select the criteria on which the partition would be created (ie: by date) and use an automated...

Hi Lowell,

Thank you very much! Now everything works exactly as it should!

Many thanks to all for your input!

Regards,

Kev

Hello again Anthony!

It is still returning NULL! My understanding is that the EVENTDATA() function is populated with the command that activated the trigger. In this case, that would...

Hi Anthony,

Thanks for the tip but it still returns NULL.....somewhat confusing...!

Regards,

kev

Hi Folks!

Firstly, thanks for the posts so far! It's always interesting to see how different people approach the same problem from different angles!

I have created the trigger now (some...

Hi SSC,

Many thanks for the link! Time to beat a couple of servers to death trying to find their limits! I'll let you/the forum know what happens!

Regards to...

Hi! Nice article so, thanks!

I have an interest though in DDL triggers in a security context with regards to accountability.

I am interested in a trigger that allows me to...