Viewing 15 posts - 3,121 through 3,135 (of 6,679 total)
For a service account, you never want to use a personal login. You need to create a separate account just for SQL Server, and depending on your specific requirements...
June 25, 2011 at 11:41 am
If this DBA changed data on the client's system - and is employed by the client, there really is not much you can do except work with the client's management...
June 25, 2011 at 11:30 am
If you have a transaction surrounding 5 stored procedure calls, and each call should result in a single row in each table that you can track to - then you...
June 22, 2011 at 6:37 pm
No - never...absolutely not.
First, although rare there have been a few occasions where applying a service pack broke existing code in the application. Service Packs should always be thoroughly...
June 22, 2011 at 5:49 pm
There has to be either a rollback occurring or another process performing a delete.
If this is something that happens on a regular basis, you need to build a trace to...
June 22, 2011 at 5:36 pm
If you have been granted the appropriate rights on the report server, you can change from the default view to the detail view (on the right side - header).
Once you...
June 21, 2011 at 8:18 pm
I would also be curious about how the TVF is created. Is it an inline TVF or a multi-statement TVF?
June 20, 2011 at 2:35 pm
homebrew01 (6/20/2011)
Brandie Tarvin (6/20/2011)
Also, check and see how often your job log clears itself out. That would be the reason why you're not seeing a history on the job.
Yes, I...
June 20, 2011 at 2:19 pm
Drop the login and recreate it with the same SID - that way, when the database is restored the SIDs match.
You can do this using sp_help_revlogin and passing the username...
June 19, 2011 at 8:14 pm
sqlfriends (6/17/2011)
But just want to clarify this, so simple recovery mode's database, they will still use transaction log, but we still need to divide...
June 17, 2011 at 2:37 pm
When I hear someone say that they have been told not to use temp tables, it usually means they are abusing temp tables and building convoluted processes to get their...
June 17, 2011 at 10:30 am
AlexGreen (6/17/2011)
There are also third party tools available to...
June 17, 2011 at 9:55 am
Dan.Humphries (6/16/2011)
The Full DB Backup runs about an hour when it is at a TB but less then 10 minutes when it is reduced to the 100GB size.
I don't see...
June 16, 2011 at 3:02 pm
sysadm 77674 (6/16/2011)
OLDCHAPPY (6/16/2011)
June 16, 2011 at 2:24 pm
Lee Crain (6/15/2011)
The lengths of the values in the REPLICATE...
June 15, 2011 at 6:38 pm
Viewing 15 posts - 3,121 through 3,135 (of 6,679 total)