Viewing 15 posts - 41,821 through 41,835 (of 49,562 total)
As I mentioned in the other thread, with SQL 2000, there isn't a really easy way to do this. You could insert the results into a temp table or table...
January 11, 2009 at 6:12 am
Do you want to see all the indexes in all of the databases on the server? If index_physical_stats is run for one database, it's easy to get index names. If...
January 11, 2009 at 6:09 am
Dugi (1/11/2009)
I don't know what is your experience with MS Access...but if you want to learn SQL you should leave Access at all!
What's wrong with MS Access?
January 11, 2009 at 6:03 am
@jit fr Cochin (1/11/2009)
Am using SQL 2000..
Please post SQL 2000-related questions in the SQL 2000 forums in the future. If you post in the 2005 forums, you're very likely to...
January 11, 2009 at 2:32 am
I wrote it as a beta exam. Fairly standard, multiple choice, pass mark 700. If you've written previous MS exams, the format won't surprise you. I found several of the...
January 11, 2009 at 2:04 am
Many of the DBCC statements have an undocumented option TABLERESULTS which changes the output of the statement from text to a resultset that can be inserted somewhere.
With OPENTRAN, it'll be...
January 11, 2009 at 2:00 am
Lynn Pettis (1/10/2009)
January 11, 2009 at 1:56 am
Look up alter database in Books Online. There's commands to add a file and also to add a filegroup. Or you can do it from the files tab of the...
January 11, 2009 at 1:50 am
Stephanie J Brown (1/10/2009)
Hakima? Which martial art?
Aikido
Mine's aikido, and in terms of dress code, our dojo has two uniforms - the white ghi, and the white ghi...
January 11, 2009 at 1:36 am
Lynn Pettis (1/10/2009)
You know, I don't know? Maybe.
Now that will look impressive in your sig...
January 10, 2009 at 1:20 pm
Typically, you don't. The transaction log is not there for data recovery and there's no built-in way (except for ROLLBACK TRANSACTION) to use the transaction log to undo a transaction.
Additionally,...
January 10, 2009 at 12:55 pm
Lynn Pettis (1/10/2009)
January 10, 2009 at 12:39 pm
What I wear on a particular day depends on what I'm doing. I personally detest skirts and I haven't worn one since highschool (where it was required uniform) and the...
January 10, 2009 at 12:38 pm
Jeff Moden (1/10/2009)
January 10, 2009 at 12:23 pm
Lynn Pettis (1/10/2009)
Sorry, I was watching the last 2 episodes of StarGate Atlantis (had them on DVR).
Any good?
Or it could be a result of the Raid 5 configuration of the...
January 10, 2009 at 1:51 am
Viewing 15 posts - 41,821 through 41,835 (of 49,562 total)