USE master

SELECT name FROM syslogins WHERE sysadmin = 1

John

Hemant

OK, thanks.  I was correct in my supposition, as you have clarified in point 2.

Just one piece of advice: go with what works the best.  Don't discount temp tables just...

Mo

It stands for Data Definition language.  Please read the following two articles, which are useful to first-time posters:

http://www.sqlservercentral.com/columnists/siyer/2645.asp, which contains a link to http://www.aspfaq.com/etiquette.asp?id=5006

John

Mo

This is just a guess because you haven't provided any table DDL.  Why are there separate tables for customers and addresses?

SELECT c.custname, a.address1, a.address2, a.address, a.postcode

FROM waddressses a JOIN wcustomers...

Ravi

What I would do is use a SELECT statement with ORDER BY EmployeeID at the end and let my front end do the presentation of the data.  If you have...

This excellent article on hierarchies should help you.

John

Vladan

The previous invoice won't be for another customer, because the data in the temp table is ordered by customer.  Have I overlooked something?

John

Hemant

First, a couple of comments on your table design.  If CustomerCode is just that, then varchar(50) is probably a bit much, especially if you are using that column to join...

DAB

Now that you're up to 16GB, have you removed the /3GB switch from your boot.ini file?

You should expect to see a low cache hit ratio soon after the server is...

Yes, a linked server is the way to go if you're going to do it regularly - although there are also ways of running ad hoc queries without creating a...

Michelle

I don't know anything about Litespeed, I'm afraid, but here, off the top of my head, is how I'd go about moving the databases.

(1) Back up all databases in case...

 "The only unique key on the tab1 is the primary key... I have checked all other col's on the table but none are unique."

You have two unique constraints on the...

Arun

Sergiy is quite right, of course.  Now, to answer your question... the following should work.  Somebody might be able to think of something more concise.  It should work no matter...

The procedure for moving tempdb data and/or log files is different from the procedure for user databases.  You need to use the ALTER DATABASE statement, if I remember correctly.  There...

Tryst

Yes, so long as it as simple as switching two values over.  Obviously if the values were 13 and 28, say, then you'd need to think about how you would...