Hi,

I tried to do this before through DTS but could not do it for some apparent reason. In the end i had to write each statement of the SP in...

You can see what instances are registered using the

isql -L

command (Capital L). This will tell you what instances have been installed on the machine... once you know which...

Hi Hilary,

And thanks for the reply, I have been searching for some resources on the web with reference to the same, and came across this document.

Its a white paper...

Hi Mani,

I recieved an error of similar nature not too long ago... It could be that the subsystem cannot keep with SQL Server, thus with the extra memory, SQLServer is...

I found this to be the case as well, just go to the options task menu in the dts step and print the data to a log file... I find...

You will have to install the client version of Analysis services Manager from the SQLServer 2000 install CD. That will create another icon when you click on start->Programs-microsoft sql server->Analysis Manager....

Hi Martin,

Thanks for the reply, but I've tried a few things, one of which was to alter the columns and change the collation. I could do that for all the...

Thanks Julian,

But I tried that yesterday and it doesnt work, because msdb is a system database it won't allow me to just use the 'alter database...' command. Some columns are...

Make sure that the databases are all in Full recovery mode. I had this same problem and it was due to the Databases being in Simple recovery mode. Give it...

Oracle support :

HP-UX

Solaris

Windows

Hp64

Linux

To name but a few...

M

Hi K,

I'm not too sure if this will help but I had to setup replication on a few instances in here. At first I was getting a lot of difficulty...

Hi Guys

Another tool that you can use is LogExplorer. you can get trial versions of this tool to test it out but its the closest I have seen to Log...

True,

BUt it still doesn't get over the fact that I will have to manually go through a list of a few thousand users each time someone leaves. I would like...

Hi Lads,

That is quite a valid point alright, but since there are so many servers/users I would like to automate the process of identifying the users to a small number...

Hi Kenneth,

I would do that if it was a once off but I am going to put together a webapp so that the people in HR can do this when...