And beware when you are creating linked server, if there are any 🙂

It depends, usually an SQL server can have upto 75% of the system CPU, if it exceeds this for a time period then you have to look for problems that...

Have u created your own maintaince plan??, if so can you post the script so we can have a look on that

Thanks Mate, it looks somthing like this, but the problem is that we are using hibernate to insert values into a table, As per my develolper he says SP cant...

Thanks Michael

But the problem was that i cant insert null...

Can you please post us the Query you use, Its not advisible to delete 70 K from the production server in a time. is this a one off thing or...

Hi

Is the XX server folder shared and has got rights for the user who is accessing the file 🙂

Search in this forum mate, its a open Question, can you be a bit more specific so we can help 🙂

Is this a whole database or a table, if its a database then why not backup and restore 🙂

Hi Steve

I do agree, i forget to mention that :), depends upon the usage

Why do you really want to do a Open Query when you have an option to create a linked server and use that server on SQL, which is more efficiant...

You can do this by opening a default trace on the profiler, run the profiler and then your appication, you can see the username and the host name from where...

Hi you are inserting all the rows from Student table when ever you fire a trigger, you have to use values...

One way u can use sysindexes table to get the row count of all the table on that databases 🙂

Use

Declare @sql varchar(255)

Declare @Sample varchar(2)

Set @Sample='5'

set @sql='Select top '+ @Sample +' * from

EXEC (@SQL)