I think that when you restore a database into other server, the database takes its collation from master database, not sure tough, but i am using different collation for my...

Hi MC

To count tables on multiple servers you can use linked servers, What are you exactly trying to...

Thanks Chris

This 2 tables are completely different, i just made a sample, in fact there are...

Thanks Lowel

This is for the applications, we are creating a auditing for application ( to...

Thanks 321, yeap I am aware of that, this is just a sample ones, if i managed to create a SQL with one Where clause then i can create a...

not sure but i think that the user needs administrator rights, try data importer or back up rights and see if the user is working on that, i am not...

looks good, there are some privileges problem with the user u ran with 🙂

think that you have to start the instance by using configuration manager, seems most likely the server instance is not started, let me know if this works 🙂

You can use SQL server agent, right click and add a new job and schedule to run on your preferred time 🙂

cursor, what else you expect from it mate 🙂

Hi Derek

First personally, i would switch off automatic updates on any servers, i dont want any one...

I have enabled my server side trace on, this takes much less overhead then using the profiler, again it depends upon your server load, enable it and then have a...

Try and run the same with a user that has administrator privileges or with sa password and see if its working 🙂

Good to know this Jacob, i was searching for this Activity monitor, thanks for this good explanation 🙂

Hi Sam

There are various factors that affect his, network , index etc, to start with i will check...