It's the SQL Server, either the name or the IP address. If the name doesn't work it's due to a DNS issue (no name resolution). When you supply your login...

Were any changes made to the Operating System? I've restored successfully after upgrading Service Packs to SQL Server so that shouldn't be your problem. But upgrading your operating system could...

I don't believe you can do what you are trying. Commas are not integers. The data you are trying to put into @na is a string, therefore the datatype needs...

I have done this with success:

WHERE mydate > CONVERT(CHAR(8), GETDATE()-1,1) + ' 05:00:00.000'

and mydate < CONVERT(CHAR(8), GETDATE(),1) + ' 05:00:00.000'

You can change the time to be whatever time you desire,...

If both nodes of the cluster can see and use the data at the same time that's an active/active setup. It also means you have to have two Enterprise Licenses...

It may be a problem with settings on your computer. I've never seen the forum nor the registration page as 'black-on-black'.

-SQLBill

ianscarlett,

eljeffo never did a full backup, ever. To my knowledge and according to what I've read in the BOL, you can only restore a transaction log to a full backup....

Here's the update (after working 36 hours of overtime). SQL Server and my data came up just fine. If you are moving SQL Server databases to a new set of...

The big thing here is that we are NOT moving SQL to new directories, new drives letters, etc. We are just moving to a new set of hard drives that...

Install SQL Server (pretend you are doing a new install). You will get to a window where you can set the instance name. There will be an option for the...

In preparation to moving my server files to new array, I had to move one database from one server to another. When I tried to add users to the database...

DALEC,

I'm sorry that you were treated that way. I can't figure out why some men seem to think women are unable to be as smart as or smarter than a...

Thanks Brian but that's not quite what I'm looking for. His directions are for moving them to another drive or drive partition. We are moving them to a whole new...

As Steve said, there are lots of intangibles. In the Washington D.C. area a security clearance can add $10K to $20K t your salary depending on which level you hold.

Sometimes...

I'm not sure I completely understand you, so...

Are you saying you already have SQL Server databases and that you just want to be able to connect to them?

If so, you...