Hi,

I use temp tables. I have a report that does statistics on data and many kinds of grouping have to be implemented. Some things have to be groupped before additional...

andrewkane17  is right, the message is just informational.

I had only 2 SQL Server failed installs during the past 5 years (both were eventually...

Steve,

We will be waiting for your report!

Yelena

server name is stored in sysdatabases. How do you connect to get @@servername? Are you on a server machine with sysadmin rights? if something happened to your server name in...

Henk,

Cursors are very close to Recordsets with a very similar syntax. I use cursors if performance is not a problem because their performance is not as good as Select statement....

You may want to use WMI scripts. See the link for an example for getting NTFS permissions for a folder

http://www.microsoft.com/technet/scriptcenter/scripts/security/dacls/sedcvb02.mspx

WMI can get to the remote computer too.

Download Scriptomatic tool...

Hi,

I had a similar task to return all values where I had a table with StartValue and EndValue fields

I created a cursor, here is a code idea. I had to...

Here was another post recently that said that if a user is a member of more then one Windows groups that his default database may conflict.

The solution suggested here...

One of developers I support did have this problem: SP 3A install on  SSQL Server 2000 on Windows 2003 server hanging on "Validating User" stage.

This machine had other Windows problems and...

Chris,

check out the article here

http://www.sqlservercentral.com/columnists/ssingh/whichdatabasesarebeingbackedupanotherlook.asp

and its discussion

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=175&messageid=119679

There are a couple of good SQL statements that query MSDB getting the last backup date for all databases.

I personally have a...

Why the only thing that comes to my mind is the word "Outsource" ?

This "SSIS-> DTS-> Package -> Task-> Script-> DTS Object" thingy should be clearly outsourced to developers. I will...

Hi,

Jamie says: "The DTS object is not available in a script component."

What about

http://support.microsoft.com/default.aspx?scid=kb;en-us;908460

How to add an incremental counter in a SQL Server 2005 Integration Services package by...

The classic scenario for Affinity Mask from  MSDN: when you have a network traffic on the server and the network card gets the highest numbered processor, next network card gets next...

I am MCDBA with 70-215 (Windows 2000 server). I got this certification some time ago when Windows 2003 did not exist yet. I found it very helpful to be skilled...

Simon,

Per server license I think requires re-install to change from Per Processor, but it all depends on your corporate agreement. Per server license suggests you need per user or per...