Viewing 15 posts - 241 through 255 (of 388 total)
mattfitz (2/18/2010)
February 18, 2010 at 10:13 pm
halifaxdal (2/18/2010)
Whoever made any attempts to log onto my server/database, I need to record that info, no matter how the user access it, failed or succeeded,...
February 18, 2010 at 9:41 pm
Try this script.
-- Drop the working table if it already exists
IFOBJECT_ID('tempdb..#tblUsers') IS NOT NULL drop table #tblUsers
GO
-- Get the users into a working table. Code is non-destructive if any...
February 18, 2010 at 9:31 pm
I am with Jason on this, most of the time jobs are run under 'sa' or SQL services account, unless you want some else (other than DBA's) is running job...
February 18, 2010 at 9:10 pm
It won't be same because by default it would be database.mdf, you can name it however ever you want. Don't worry about it, it is not worth. If you want...
February 18, 2010 at 8:20 pm
I would prefer to run under same domain account which is used for SQL services.
EnjoY!
February 18, 2010 at 8:00 pm
Check this out.
http://www.sqlservercentral.com/articles/Backup+and+Recovery/restoringtoapointintime/1905/
EnjoY!
February 18, 2010 at 7:55 pm
And i also feel i should keep away from this Blog, as when ever i replied to question looks like other DBA's are not happy.
Time to hit the road!
EnjoY!
February 18, 2010 at 4:20 pm
GilaMonster (2/18/2010)
GT-897544 (2/18/2010)
GilaMonster (2/18/2010)
GT-897544 (2/18/2010)
If that is the status values for suspect databases. Looks like it is a clean shut down, no corrupt files.
It's not.
Cleanly shutdown is indicated by...
February 18, 2010 at 4:18 pm
GilaMonster (2/18/2010)
GT-897544 (2/18/2010)
If that is the status values for suspect databases. Looks like it is a clean shut down, no corrupt files.
It's not.
Cleanly shutdown is indicated by value 1073741824...
February 18, 2010 at 3:26 pm
Alvin Ramard (2/18/2010)
GT-897544 (2/18/2010)
Lynn Pettis (2/18/2010)
GilaMonster (2/18/2010)
GT-897544 (2/18/2010)
February 18, 2010 at 2:49 pm
Lynn Pettis (2/18/2010)
GT-897544 (2/18/2010)
Lynn Pettis (2/18/2010)
GilaMonster (2/18/2010)
GT-897544 (2/18/2010)
February 18, 2010 at 2:44 pm
Viewing 15 posts - 241 through 255 (of 388 total)