I know you can set RETRY count (and interval?) for SQL Job

but I don't think it makes sense logically to fix it and pretend it did run in the past...

Do you mean YOU as "currently"? or always use your windows authentication even if the linked server is executed by other SP's or users?

For 2000, Books Online

http://msdn.microsoft.com/en-us/library/aa213778(SQL.80).aspx

Books Online 2005/2008

http://msdn.microsoft.com/en-us/library/ms188477.aspx

Linked...

+1 for Re-read my replies 😀

Yesterday on a SQL Server

We changed the SQL Server Service account from "Local System" to "DOMAIN\user" (and restart SQL Server after) that has access to...

checkai (12/4/2008)

---

I have also seen the use of a rectangle with a conditionally shown/hidden rectangle within it. This method has worked for me on occassion but is very finicky. Surprisingly,...

I always use the Generate Script technique, it includes the schedules as well

some notes

- you may need to create Categories if you have some custom ones

- you may need to...

Just to add, I did this trying to use for 70-431 exam

Downloaded the AdventureDB.msi (28MB) from CodePlex

ran the install, specificy a location, and it simply creates/extracts the MDF and LDF...

23 hours seemed excessive for 147GB

You should try backing up to LOCAL drive first (if space allows), do a Verify Backup as well

then use some copy utilities (RoboCoyp, TotalCopy, TeraCopy)...

Permissions of Fixed Database Roles

http://msdn.microsoft.com/en-us/library/ms189612(SQL.90).aspx

Google

http://sqlserver-qa.net/blogs/perftune/archive/2007/09/10/1960.aspx

As usual if that login needs the execute permission you have to "grant execute" permission on sp(s) you want login to execute, also ensure that user...

You could utilize the sp_MSForEachDB if you don't want cursor

but same idea.

sp_MSForEachDB 'ALTER TABLE ? ADD ColumnName ColumnType'

As for second question, it does sound dangerous

but my thinking is cursor for...

I am confused by the RAID 10 and RAID 10 part

We're getting two big SQL boxes - Windows 2008 Enterprise 64-bit, SQL Server 2008 Enterprise. The machine has 4...

A workaround is to create a Windows Local User Group on the server

add the domain users/groups into it, then add the Local User Group to SQL Server

If that works, at...

GSquared (12/3/2008)

---

Insert the log data into a table variable. Then, in your error handling, after the rollbacks, insert it into the final table. That should give you what...

Gaby Abed (12/3/2008)

---

atulkumar2 (12/2/2008)

---

Hi Rajeev,

The best you can achive by using the third party tool. Some of them are as LiteSpeed by Quest Software and SQLBackup by Radegate.

I am not...

For Restore

- there is no object level recovery in SQL natively (3rd party tools yes)

- restore as a new DB, and copy the tables manually

As for data differences, you have...

I have downloaded it gonna give it a try

It looks........... complicated 😛 but powerful