couldn't ALTER DATABASE msdb SET SINGLE_USER fail if other processes are in it?

does SQL2000 have WITH ROLLBACK IMMEDIATE?

ALTER DATABASE msdb SET SINGLE_USER WITH ROLLBACK IMMEDIATE

i think using the row number with a sub select will get you what you are after:

SELECT

Employee_ID,

Employee_Title,

Employee_Entry

FROM (SELECT

...

can you check the database compatibility of the database?

i remember that SSMS disables Intellisense for SQL2005 (even though it's possible to enable it);

maybe that functionality is based on checking the...

Pretty much the same reason you upgrade FireFox, Google Chrome or any other...

rather than thinking of tickets you might encounter, think of the responsibilities the production DBA has, and evaluate yourself on which items you cna do, and which you want to...

Missing a comma and also a closing parenthesis on the log:

changing the layout for readability was what made me see it:

Create database ToddTestDB On Primary

( Name = N'ToddTestDB',

FILENAME...

the last selection should just be an ELSE;

SELECT

CASE

WHEN CARS.Model LIKE '%Ford%' THEN 'Ford'

WHEN CARS.Model LIKE '%Chev%' THEN 'Chev'

WHEN CARS.Model LIKE '%Buick%' THEN 'Buick'

ELSE 'All Cars'

END AS 'Models'

BACKUP default directory

http://www.sqlservercentral.com/Forums/Topic1319398-1550-1.aspx

/*

In case it was not clear in Jason's post, the @key parameter value remain consistent

across all of your instances. The proc he is calling does proper registry...

On a completely unrelated note, I started making a post asking someone for a working example of a linked server for Access using the ACE drivers; about halfway through creating...

yeah this was from my SQL 2000 notes, so we are talking really old school code;

It Used to be possible to map a drive by throwing a key in...

an example via xp_cmdshell from an old post;

the obvious problem is the script contains a cleartext password.

if the shared drive was already set up at the operating system level, the...

AndrewSQLDBA (5/14/2013)

---

I have not been able to every find that SSMS will do that. I was hoping that someone had found a way.

I have the SSMS Tools. So how would...

A couple of other ideas ,depending on who it is you want to keep out of the database restore the database with a name noone would connect to.

and another...

S_Kumar_S (5/14/2013)

---

Hi All

I wish to store a word document in SQL Server. I should be able to search on the content. e.g. Select Content from DocTable where content like '%this...

well, the xml you posted is malformed; it is either missing two tags in the middle, or these two tags below need to be removed from the middle:

the...