Here's an example:

C1 C2 C3

1 a hello

1 b candy

2 a car

2 a ...

One other place you need to check. In Enterprise Manager, right click on your server. Select Properties. Go to the Security tab. What type of authentication does the Server permit?

1st...

Use Enterprise Manager, drill down to Security, right click on Logins, select New Login. Fill out the information.

On the General tab is where you set the LOGIN name, type of...

Did anything change on the server? Did you change accounts/passwords for SA? How about for the SQL Server and Server Agent services?

What login is the maintenance plan running under?

-SQLBill

Are they set to Automatically start? Or do you have to manually start them? (Right click on My Computer, select Manage, look for Services, find the MSSQLSERVER Service and the...

I created two log backup jobs. The first one of the day (4 hours after the Full Backup) runs using the WITH INIT command. That initializes (overwrites) the backup file....

Use this in ALL your queries:

SET DATEFORMAT dmy

-SQLBill

Try something along this line:

WHERE Due_Date > DATEADD(HOUR,0,DATEADD(DAY(DATEDIFF(DAY,0,GETDATE()),0))

AND Due_Date < DATEADD(HOUR,0,DATEADD(DAY(DATEDIFF(DAY,-1,GETDATE()),0))

-SQLBill

The transaction log is only important if you want to be able to do 'complete' restores or 'point-in-time' restores.

First, you need to be doing regular backups. You should have at...

It relates to this topic...

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=16447&FORUM_ID=8&CAT_ID=1&Topic_Title=CREATE+RULE&Forum_Title=T%2DSQL

Riga1966 just started a new thread instead of responding to the original one.

-SQLBill

You need to look at this Microsoft's way. Eventually your cluster will fail and the passive side (4 processor) will become the active side. This could happen just by rebooting...

quote:

---

I tell you, it is not all the time funny to have someone like this around when it comes to writing.