Viewing 15 posts - 871 through 885 (of 984 total)
Sysindexes is deprecated - now that's a good reason.
Thomas Rushton
blog: https://thelonedba.wordpress.com
June 3, 2010 at 7:19 am
steveb. (6/3/2010)
ThomasRushton (6/3/2010)
steveb. (6/3/2010)
ThomasRushton (6/3/2010)
only4mithunc (6/3/2010)
One more...You can execute this in the DB where you want to check
execute sp_MSforeachtable @command1= 'select ''?'' TableName,count(*) NumberOfRecords from ?'
You could do...
Thomas Rushton
blog: https://thelonedba.wordpress.com
June 3, 2010 at 7:03 am
steveb. (6/3/2010)
ThomasRushton (6/3/2010)
only4mithunc (6/3/2010)
One more...You can execute this in the DB where you want to check
execute sp_MSforeachtable @command1= 'select ''?'' TableName,count(*) NumberOfRecords from ?'
You could do that, but it's...
Thomas Rushton
blog: https://thelonedba.wordpress.com
June 3, 2010 at 6:38 am
popuri.s09 (6/3/2010)
Hi All,pls pls reply for my question.
how to capture audit task (taskname,taskstarttime,taskendtime)
omn succcess of the tasks in package.
thanks
Syamala
Aren't these the same question?
http://www.sqlservercentral.com/Forums/Topic931952-391-1.aspx
http://www.sqlservercentral.com/Forums/Topic931956-391-1.aspx
Thomas Rushton
blog: https://thelonedba.wordpress.com
June 3, 2010 at 6:29 am
Paul White NZ (6/3/2010)
bteraberry (6/2/2010)
Thomas Rushton
blog: https://thelonedba.wordpress.com
June 3, 2010 at 6:26 am
only4mithunc (6/3/2010)
One more...You can execute this in the DB where you want to check
execute sp_MSforeachtable @command1= 'select ''?'' TableName,count(*) NumberOfRecords from ?'
You could do that, but it's horribly slow... ...
Thomas Rushton
blog: https://thelonedba.wordpress.com
June 3, 2010 at 6:17 am
If you want to do it via T-SQL, you could use as a starting point:
USE msdb
GO
SELECT j.name,
h.step_name,
...
Thomas Rushton
blog: https://thelonedba.wordpress.com
June 3, 2010 at 6:15 am
Tom Schuettke (10/20/2008)
I believe an 18456 with state 16 = No permissions for target database or target database offline.
Having done a fair bit of trawling for reasons for Error 18456...
Thomas Rushton
blog: https://thelonedba.wordpress.com
June 2, 2010 at 7:17 am
MarkusB (3/23/2009)
Graham.Okely (3/23/2009)
Does anyone know where xp_delete_file is documented?There is no official doumentation from MS.
See here http://sqlblog.com/blogs/andy_leonard/archive/2009/03/11/xp-delete-file.aspx for some unofficial info.
The official line from MS seems to be that...
Thomas Rushton
blog: https://thelonedba.wordpress.com
May 28, 2010 at 8:39 am
FreeHansje (5/28/2010)
Is there any way I can check if a login has this permission?
The permission to "ALTER SETTINGS"? Log in as that user, and do a select * from...
Thomas Rushton
blog: https://thelonedba.wordpress.com
May 28, 2010 at 6:43 am
If you want to do this, your user accounts need to have the "ALTER SETTINGS" permission set. This is a server-level permission, and, by default, is only set in...
Thomas Rushton
blog: https://thelonedba.wordpress.com
May 28, 2010 at 6:14 am
troy2.net (5/27/2010)
What i did wrong ?
Well, it would have been nice if you had actually asked a question, rather than just say "Difference in Features etc..."
Thomas Rushton
blog: https://thelonedba.wordpress.com
May 28, 2010 at 2:02 am
I'm glad I've found this thread. I've got about 40 servers with about 230 databases that need to be migrated... and I've got a big mix of service...
Thomas Rushton
blog: https://thelonedba.wordpress.com
May 28, 2010 at 1:58 am
I've just had the same problem on a SQL2005 Standard Edition SP2 box that's not very active.
The only other thing that has logged an issue at a similar time on...
Thomas Rushton
blog: https://thelonedba.wordpress.com
May 7, 2010 at 2:55 am
Been there, done that, got the T-shirt... at previous work-place, the aircon in the server room failed one evening. The first time our support guy noticed was the next morning,...
Thomas Rushton
blog: https://thelonedba.wordpress.com
June 7, 2004 at 4:02 am
Viewing 15 posts - 871 through 885 (of 984 total)