I think Muhammad meant "Ethically NOT allowed" in regards to asking for answers to interview questions.

-SQLBIll

We don't have enough information to help you. What kind of system are you installing it on? The fact that you couldn't even load the Express edition tells...

Are the logins on both SQL Server and using SQL Server Authentication?

From the looks of the examples you gave, those aren't SQL Server logins.

Windows Authentication can ONLY be used with...

When you backup a database to a file, SQL Server 'records' that information. It does NOT keep checking to make sure the information has stayed the same. So if the...

Look up Orphaned Users in the BOL. That will show you a script to run to find out which logins are 'orphaned'.

-SQLBill

ALTER TABLE tblname

ADD COLUMN myid IDENTITY (1,1)

Adding an IDENTITY column can take a while as it needs to number up every row in the table.

-Bill

Just like any other database. However, you CANNOT do a transaction log backup of the master database. If you use a maintenance plan to do the backups, make sure...

You could use REPLACE. First replace all commas with 'no space' REPLACE(string, ',', ''). Then replace all slants with a comma, and all spaces with a comma.

-SQLBill

How did you do the restore? Did you make sure to use WITH RECOVERY? If not, then the database will continue to show recovering. One of the first...

No they are not the same.

The first one only returns rows where dist.cdedoctype equals 'INV'.

The second one returns rows where dist.cdedoctype equals 'INV' OR has a NULL...

In Enterprise Manager, right click on the instance, select Properties. Go to the Security tab. You should see a section for Auditing. Check the box for successful logins.

-SQLBill

Every job does have Step 0. It is the job outcome. Open Enterprise Manager. Expand Management. Click on Jobs. Right click on any job that has run and...

Why use SP1? SP2 is now out and that's what I would use. I don't have a 2005 cluster, so can't help with that. But I wouldn't apply...

I don't know....what is the error? If it didn't work you should have gotten an error message - what was it? If it didn't return what you expected...

First: who owns the table? Look in Enterprise Manager, expand the database, click on Tables. Look down the list to find the table. Is the owner DBO or...