Did you have to reload SQL Server? If so, did you use all the same settings? And apply all the same Service Packs?

If the Version and Service pack aren't the...

How are you attaching your database? That type of error usually means that the LOG file (.ldf) doesn't match the DATA file (.mdf).

You could try just attaching the .mdf and...

I'm not positive about this, but...

I looked at Batches, overview in the BOL and it says that CREATE command begins each batch. So, it seems there is an 'implied' GO...

The basic issue with the warnings, is that without Transaction Log backups you cannot restore to a 'point-in-time'.

Full and differential backups are restored as 'all or nothing'. You can't restore...

Well, I used to be a member of SSWUG....but I quit after a year. I had posted queries to their site and couldn't get any answers. I also noticed that...

SSWUG is not just a website for information on SQL Server. It's an official organization (SQL Server WorldWide User's Group). They just happen to also operate a website for their...

You could use SUBSTRING and LEN:

DECLARE @mystring VARCHAR(10)

SET @mystring = '123456789'

SELECT SUBSTRING(@mystring, 4, (LEN(@mystring))

LEN finds the length of the string. Then SUBSTRING extracts the portion of the string starting at...

The error message is correct...look at your FROM:

FROM ((tblApVendor INNER JOIN tblApHistHeader ON tblApVendor.VendorID = tblApHistHeader.VendorId)

   INNER JOIN tblApCheckHist ON (tblApHistHeader.InvoiceDate = tblApCheckHist.InvoiceDate)

       AND (tblApHistHeader.InvoiceNum = tblApCheckHist.InvoiceNum)

      ...

Gary,

To (hopefully) add to your understanding. If you could 'set' the TraceID, then you could accidentally assign the same ID to two different traces. So, the trace create command won't...

Dinesh,

Steve or someone can correct me if I'm wrong, but....

Let's say I write an article. I own that article and can submit it wherever I want to. So I can...

Another to check is:

http://support.microsoft.com/default.aspx?scid=kb;en-us;122180

and scroll down to 322.

-SQLBill

This link from Microsoft might help:

http://support.microsoft.com/default.aspx?scid=kb;en-us;230393

-SQLBill

Unless I'm wrong, can't you define a Primary Key as a combination of columns?

In your scenerio, you can't use the customer credit card number as a Primary Key because they...

Schedule it via Jobs.

In Enterprise Manager drill down to Management. Then drill down to Jobs. Right click on jobs and select new job. Fill out the information.

In the Steps...

When you installed SQL Server, what type of authentication did you set it for (Windows Only or Mixed Mode)?

Did you register your server in Enterprise Manager? That's not the same...