By Default only Sysadmins will have execute permission to this extended stored procedure. so you can count on all logins with sysadmin roles.

And, if you have created xp_cmdshell Proxy Account...

All been said is true, if you want to automate this process of shrinking logfile soon after SQL Server takes SQL Server log file then do this,

Create a job, with...

If Job only takes backup then assign the user to db_backupoperator database role for that particular database which it is taking backup of.

To take backup of the database user/login don't...

Hello,

Just look at this, if this make more sense ....

SELECT A.name 'TableName', B.name 'ColumnName', C.name + ' ( '+

CASE WHEN B.length = -1 THEN 'MAX' ELSE CONVERT(VARCHAR(10), B.length) END +...

You said your database is gone, then on which database are you trying to force restore this backup file.

I think you created a dummy database on which you are...

Does bstadmin have access to the database on which all these jobs run. You dont have to give sysadmin priviledges, nor you have to assign any sysadmin logins to these...

Does this helps...

I have written some thing like that earlier... this might not be good per performance wise... but this will give you a start ...

Click here for link...

Can you use openrowset, read more abour Openrowset here. Click Here

This connection does not requires a Linked server, you can run quires directly onto secondary.

Hope you can use this...

Since you are interested in replicating all the 100 tables in a database, why don't you consider Log shipping as your Solution. With Log Shipping you can also keep you...

I dont know how you do this, but once you get the spid which is creating a row lock on that table, then using sysprocesses you can get all the...

Yes, That is correct make sure your browser service is Running.

Start- run - services.msc , hit enter.

check for SQL Server Browser , if this is running or not....

I would do very simple test... go and check the .mdf and .ldf files on the operating System. Check for Date modified. Thats when these databases were used ( insert/update/delete...

Very easy and best way to do this which involves no Scripts and no hassles.

Create a DTS/SSIS package

create a source connection to sql1 database

create a destination connection to sql2...

If you want to replicate whole database. And you want your destination database only for Reporting, then I suggest you do log shipping instead of Replication.

Thanks,

Imran Mohammed.

I use sp_help table_name

gives me all details of tables, including column names and their data types and data lengths ( if any ).

Thanks

Imran Mohammed.