Unfortunatly, it is SQL Services. If you have an instance, you can just restart the instance of that but still, it is still SQL Service. (i.e MSSQLSERVER for default instance)....

A little off topic from here but just curious that if anyone installed SQL STD on 4 way box with HT (i.e, 4 physical + 4 logical) on windows 2003...

Thanks,

I made the connection work.

First, your declare is wrong. You forgot "@" for variable.

DECLARE RUNDATE DATETIME -> DECLARE @RUNDATE DATETIME

Second, what is the dateformat that you want? Yours look like [dd/mm/yyyy]. American standard is...

Hi,

I think I need the real example. Those documentation doesn't include to to link server the AD. I tried below but keep getting error message as below. Do you have...

This is exactly right information that I was looking for.

Thanks Brian.

Kun

I am sure other folks can answer a lot better.

First, I am not big fan of Visio for dta modeling. Maybe I don't know enough to do all the...

Thank you so much Bart,.. this does sounds like the solution.

Anyway, please correct me if I am wrong.

If you need to insert on other database and have sp3a installed, either you have to enable "Allow corss-database ownership chaining" or give...

That is very good to know. Do you know if it requires any resource from Source DB?

Thank you in advance,

Kun

Thank you for the input. I will keep in mind that.

Nop, not at all. If you want to use name, register the server by using "SQL Server Client Network Utility" and name whatever you want.

Still you should be able...

Do you have any dump file? anything on Event Log and SQL Error log?

Also, make sure to have latest service pack for SQL and O/S.

What Taj suggest is correct. Even though you have enough room to growth, you shouldn't let the SQL server to take care of the growth because it might grow in...

Where is the system database files?