Viewing 15 posts - 31,471 through 31,485 (of 39,754 total)
Some of these are system processes (Task Manager, etc.) so there's nothing to do with these. The Awaiting Command ones are usually idle client connections.
September 3, 2007 at 12:26 pm
How much free space do you have in you database v the size of this table? Maybe there's no enough extents in a row to build the table. You might...
September 3, 2007 at 12:25 pm
You could set up a check for the file timestamp with a script of some sort. In SQL 2000, I'd probably set a DTS package that uses VBScript to check...
September 3, 2007 at 12:24 pm
Denis,
I'm not sure there's an easy way to run this report without performance issues. You can set up a clustered index on the date, which will limit he amount of...
September 3, 2007 at 9:40 am
I'm not sure how many times you should go through the book, but you should be able to add/delete/edit the following:
- Logins
- Users
- Databases
- Schemas
- Roles
- Permissions to any object...
September 2, 2007 at 7:40 pm
I took this after writing part of the Sybex book. It was fairly routine and I didn't think it was overly difficult. Of the 4 I've done (431, 441, 443,...
August 31, 2007 at 9:13 am
Doing some projects would definitely help and I'd consider them. Especially if you could bring a version to teh interview on a laptop, explain how/why things work.
I'm not saying you're...
August 31, 2007 at 9:12 am
Michael has it right. Look up Multi-Server Admin in BOL or Master Server/ Target Server.
August 31, 2007 at 8:28 am
The way to do it would be to insert rows into the temp table and manipulate them, then select out all the rows as your message. Not sure how this...
August 31, 2007 at 8:27 am
Have you tried it with replacing SHEET$1 with something else?
August 31, 2007 at 8:23 am
There are numerous scripts on this site that will write a new file based on the date. I'd recommend different dates since I've had issues iwth a single file before.
August 31, 2007 at 7:46 am
I'd still think you are a junior DBA since so much of SQL Server is different from Access. There are definitely cross overs in the database design, understanding how tables...
August 31, 2007 at 7:45 am
Strange question, but I'd go with the union as well.
August 31, 2007 at 7:43 am
Agree with John. We came up with a hack to force changes in SQL2000, but we couldn't deal with complexity.
August 31, 2007 at 7:41 am
Are you sure that Mixed mode is enabled on the server? Make sure you're connecting the same way, same name/IP and same protocol.
August 31, 2007 at 7:40 am
Viewing 15 posts - 31,471 through 31,485 (of 39,754 total)