Viewing 15 posts - 43,906 through 43,920 (of 49,571 total)
The MCDBA is for SQL 2000 and is close to retirement, if not already retired.
Look at the MCITP (Database admin) for SQL 2005.
October 11, 2008 at 8:19 am
ronefrati (10/11/2008)
October 11, 2008 at 8:09 am
You cannot attach a database on a network drive. Copy the file to the server's drives and you'll be able to attach it.
October 11, 2008 at 7:58 am
ronefrati (10/11/2008)
Unfortunately It is obvious that you are hardheaded without dynamic thinking.
That was uncalled for. Please be respectful and polite to the other forum members, especially the ones you...
October 11, 2008 at 7:55 am
Do you have any filters on the trace? Are you sure that the app's pointing at this database?
October 11, 2008 at 7:46 am
saby (10/11/2008)
This might happen due to conflicts happens some time mainly in this subcription database ... due to which it might showing transaction still pending while truncating the...
October 11, 2008 at 7:45 am
Jerry Hung (10/10/2008)
I don't have MSDN, debating on what to do for my home serverWindows 2008 Trial and SQL Server 2008 Trial? hee hee
Dunno about the OS (Windows home...
October 11, 2008 at 7:39 am
What do you want help with? I'm not sure I understand what's wrong.
October 10, 2008 at 8:00 am
There's no tool I know of that does that. I had an idea to write something like that a year or so ago, but it never got started.
The schema is...
October 10, 2008 at 7:46 am
Brandie Tarvin (10/10/2008)
I've actually stumped people with simple backup & restore questions of all things. You'd think *that* particular subject matter would be basic to everyone's DBA knowledge.
Oh, please... Just...
October 10, 2008 at 7:04 am
saby (10/10/2008)
gail ..its a subcription database ..... and a live database
we are using sqlexpress edition for subcription database
Yes, I know. You said so before.
The above commands will create...
October 10, 2008 at 7:01 am
They have uses. The main one for me is error/progress logging in procs. If all that you're doing to a table var is inserting and then selecting the entire table...
October 10, 2008 at 6:56 am
Grant Fritchey (10/8/2008)
October 10, 2008 at 2:51 am
Michael Earl (10/8/2008)
While it is running, look for tables in tempdb:SELECT * FROM TempDB..Sysobjects WHERE Type = 'u'
Temp tables and table variables are added to the TempDB system tables when...
October 10, 2008 at 2:46 am
Statistics are only kept on the first column in any non clustered index i.e. SQL Server will use the first field to determine whether an index should be used.
Yes and...
October 10, 2008 at 2:41 am
Viewing 15 posts - 43,906 through 43,920 (of 49,571 total)