If moving the backup file due to a 2GB limit is the problem, could you backup the database to more than one file. Then move each file independently?

Or, fix the...

It would help if the dates where stored in date data types.

Using the following would work:

declare @datedifference TABLE

(

id INT

,start_date INT

,end_date INT

)

INSERT INTO @datedifference VALUES (10,20091202,20100629)

INSERT INTO @datedifference VALUES (20,20071202,20090330)

INSERT...

Thanks. I've already checked this and the SPN's are set up.

The best guide I've found which details how to resolve this issue is this one which I...

Probably the best answer to this question IMHO would be to explain both GETDATE() and CURRENT_TIMESTAMP, including a short version of the pros and cons (without sounding condescending like the...

Jeff Moden (1/8/2015)

---

Now, based on what I just said, one of my first questions on an SQL Server technical interview for DBAs and Developers alike is "How do you get...

You could just use a replace in your select

SELECT REPLACE(<columnName>, '.','. ')

FROM <tableName>

May not be efficient, but would work.

With the quorum, I would say you could just remove this from the cluster and then delete the disks, then re add them and set the quorum up again. ...

If you can, I would create new drives which are sized correctly and add them to the server. Shutdown the instance. Copy the data files and log files to...

There is still one or more connections to the database. Exec sp_who2 and look to see what connections are connected to your database.

Perfect. Thanks.

Do you use mirroring?

If this helps, I install the following procedure on all SQL Server instances I set up and create an agent job which runs the proc each morning to tell me...

We experience this a lot when our DC's are patched. Especially on busy systems where lots of connections occur from domain users.

We're yet to find a decent solution to...

Thanks for the reply. It's funny how you spend ages on something, then when you write it out in a question on a forum, the answer comes to you.

I ended...

Is the SQL 2000 instance running with a domain account and does this domain account have read access to the file share where the backup file is?