I have faced this and i had to uninstall SQL completely and then install a new installation, it worked 🙂

Thanks Jacob

thats what i was looking for

🙂

I need to make the 2 SQL statements into one, is'nt there a MERGE statement on SQL 2005 🙂

Are you running on the local machine or are you connected to a remote server, which SQL did you use mate @@version or the second one recommanded by allen 🙂

Thanks Nikel

We are using java hibernate to connect to SQL server, i need to know...

Hi

Is both the SQL servers are 32 bit?? if the server one is 64 bit try to set max memory for SQL server

Cheers

🙂

So you cant connect to the remote SQL server, and you did all the configuration that has been mentioned above 🙂

If i am understanding it right ???

Also have a check on the Network configutaion on SQL Configuration manager 🙂

it dosent seems to be large databases, i would shrink log files and save space, take a backup and then restore it to the place where you need them. its...

which version of SQL are you using????

If you are using SQL 2005 Management Studio then you can see the server version as 8.xx on object explorer, else you can use select @@Version to check the server...

Yes - settings are 1000 Max size and 100 Max rows per job

This means that only 100 Rows will be stored per job, if the job tuns evey...

is history log size enabled ??? 🙂

Hi Adam

U mean u detached the database from drive c and then tried to attach on drive E, are you...

if you are looking to find out your SQL license then use Select @@Version, this will let you know what version of SQL you are using and also the Windows...