1. "One man's trash is another man's treasure" as they say. It is also very true the other way around. The software that works well for a certain business model...

Andy,

This is cool. Good article.

Did someone try to restore MSDB as another database (I did that) , rename the syspackages table (I did not do that yet) and get data this...

David summarized everything correctly.

You may want also to read an article here posted just yesterday that describes roles for Agent users so they will be able or not will be...

I would run Profiler on the second machine during the upload and see if any of the activity goes towards the first machine. It could be not the SQL Server...

Please see

http://www.microsoft.com/sql/howtobuy/processor.mspx

Processor Licensing Model

http://www.microsoft.com/sql/howtobuy/multicore.mspx

SQL Server Multicore Licensing Policy

The second link is if you have questions how to license a processor with 2 threads.

You would also want to ask your IT department. In some companies Enterprise Agreement may include SQL client licenses into agreement as well as some other clients.

I think Jennifer is asking about the registration group. Right-click on the top-most entry  in EM and select to create a new group from the context menu. See

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_servpem_7jua.asp

How to...

Natalie.

Here is a link on how to do it in VBscript using WMI objects. This link has a code example and links to other code examples. Incidentally the name of...

This is a good solution. Good job!

Is it a question about SQL Server 2005 or SQL Server 2000? Depending on the version you can assign users to different roles, so they will not be able to...

I tested that on my test server by creating a server alias and having 2 registrations in EM: one for sysadmin and one for the serveradmin only. I do observe...

Hi,

I tested your query on my database containg more then 600 tables and I got the same result when outputting to Grid. This is expected: you are running the cursor...

You will have to look out for the domain account that will run the job. All copy jobs require NTFS Write permissions, so the domain accounts for Agent service account...

Could you please post the relevant code here? It looks like the query tries to return many resul sets, it is not the big size of data, it is many...

The first part of the question does make no sence even with my English.

The second part is asking how many databases we can access from a stored procedure, not from...