no ;

the public role is kind of like the "Everyone" group in Active directory;

it's required for the system to work, everyone belongs to it. it cannot be removed.

you can, hoever...

your issue is from the union of the query;

the aliases for column names always come from the first query in the union, and right now all the columns have...

nolock is always ignored for insert/update delete statements, as honoring that...

a very basic model to help you visualize the process:

SET ROWCOUNT 50000

WHILE 1 = 1

BEGIN

UPDATE dbo.myTable

SET MyField...

well, it's going to be an extra/separate process to save the view definitions, but you could at least automate it;

for example, you could guard all the view definitions, restore, then...

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...