What's the OS version ? are you using a windows server or a windows xp ?

Cheers

Yeap,

just make sure you schedule it to run after the app pool recycle time. I've done this for a WSS 3 site, same as callum. In my case, the problem...

Hi there,

Try not to use the desktop to store the backup because the SQL service account may not have access to it. Instead, replace C:\Documents and Settings\swdev.team\Desktop\bak\ITAM with something like...

Hi there,

The reason is that the application pool in IIS, by default, is set to recycle once a day. So, the first time the SSRS site is called, the IIS...

Hi there,

I don't think you can achieve that easily. If I'm not wrong, there's no way to identify who's running the report if you store the credentials inside the report...

Hi Chandu,

What's the state of the services (SQL and SQL agent) you're seeing ? Are they empty or you can start / stop them ?

Inside the registry, you can find...

Hi,

1) i want to put the 4 tables in memory

the estimated size of these four table is 2 GB and available memory at databaser server is 16 GB, can any...

Hi there,

I'm a little confused on the procedure you have used

After I have used the CA Arcserve DR process and all my data has been restored to my system and...

Hi there,

Thanks for sharing this simple yet useful scripts. One thing that you should change though is the was you execute the Use DB because you can have a DB...

Hi oscar-powell,

I'm having the same situation in an UAT cluster configured as Active/Passive. I wanted to install SP3 last sunday and I got the same error: No passive nodes were...

Hi Selaine,

On your question about running SQL 2000 and 2005 on the same box, the answer is yes, you can do that. And for setting the instance to use only...

Hi there,

you can use sqlcmd.exe utility from command line to call the sp and pass all the parameters needed.

Cheers

Hi,

Actually, you cannot debug in SQL but in Visual Studio. To do that, you should deploy the CLR using VS and the call to the SP within VS. That will...

Hi Vani,

sorry for the late response... About mirroring a clustered database, there's no special consideration but the basic clustering plus mirroring ones. After having the two clusters up and running,...

Hi Vani,

You should consider mirroring as another step on the SQL high availability solution. In our company, we have a clustered instance with some databases mirrored to another clustered instance.

Cheers,

Alejandro