I don't believe so...never thought about doing it personally.

If the columns need to come out in the correct alphabetic order, you could alter the select statement to call the columns...

Hi,

First off, to view the current locks in Query Analyser, you can use the sp_lock tool. This gives you plenty of info. Or you can use EM. Drill...

Hey,

There is no way using MSSQL tools. But you can purchase 3rd party tools such as Lumigents Log Explorer (www.lumigent.com).

Very good tool!

Clive

Clive Strong

clivestrong@btinternet.com

Thanks Steve! Very good series. Given me a few idea's to chew over...

Clive

Clive Strong

clivestrong@btinternet.com

Hey,

I was going to create a new topic here, but thought I'd jump on the end of this one as it kind of takes the initial question a step further.

We...

Hey,

Sorry, forgot to mention, backup your TLog again after you shrink the file. You should notice that it will have shrunk!

Clive Strong

clivestrong@btinternet.com

Hey Julliff,

When you backup the log file, the log is truncated to leave only the active portion of the log file. This will not effect the log file size...

Again, not SQL Server, but following on from Steve's post...Guys and Gals at an ATM.

Boys:

1. Drive to the bank, park, go to the Cash Dispenser

2. Insert card

3. Dial code and...

Hey,

Great article. I was wondering how far out I would be with my naming conventions, but fortunately, I use pretty much all of those. Only ones I had not...

Hey Shaley,

Unfortunately, this is not possible. You can only restore the Database backup and not single tables within. You could restore it with a different name and then...

Hey Chandu,

There are a few things to check...

1) Are there any users connected to any applications which access your HelpDesk DB? If so, have them log out.

2) Are you using...

Hey,

Had the same issue yesterday with the ActiveX object not being created. Turned out I missed a couple of DLL's that the dtspkg.dll file needed to register itself.

To find...

You would not be able to detatch the master database while the Server is running. When you detatch & reatatch databases it reads/writes to/from the master database.

You can only...

Chandu,

1) Yes you can. If you right click on the database, go to "All Tasks" and then detatch Database.

2) Once Detatched, move the files to wherever you want them...

Hey Chandu,

Easy way is to use sp_detatch_db and sp_attatch_dp

For example

exec sp_detatch_db 'MyDB'

exec sp_attach_db @dbname = N'MyDB',

@filename1 = N'e:\mssql\data\MyDB.mdf',

@filename2 = N'l:\mssql\logs\MyDB_log.ldf'

Hope that helps!

Clive

Clive...