[font="Verdana"]The Cumulative update for sp3 has been released now and is available for download. The update can be downloaded from the link

http://support.microsoft.com/kb/959195[/font]

[font="Verdana"]

Just a thought...

Looks like it is making a note of security events observed based on the fields in the table.

I think, there might be functions, in there that might...

[font="Verdana"]'sp_addrolemember' does not take DBname as a parameter. You have to execute the script in each db, something like:

USE SMS

GO

EXEC sp_grantdbaccess 'Services\RThomas', 'RThomas'

GO

EXEC sp_addrolemember 'Services_DBA', 'RThomas'

[/font]

[font="Verdana"]Wasn't syslogs removed in SQL Server 2000?[/font]

[font="Verdana"]

Can you check, who owns the jobs and what permissions does that account have in 2000 and 7.0? Although, in both cases the job runs under the context of the...

[font="Verdana"]

In your case the 'target_size' parameter is not specified. So, the SHRINKFILE reduces the size of the file to the default file size or the last boundary of the allocated...

[font="Verdana"]

If your databases are not too big, use the copy database wizard from 2005 instance and instead of attach/detach method, select the 'SQL-DMO' method, on the next screen you can...

[font="Verdana"]

Hi,

Can you run a DBCC CHECKDB, with the following options:

DBCC CHECKDB ('database_name') WITH ALL_ERRORMSGS, NO_INFOMSGS

Please post the full output here. We have a few very good folks who can...

[font="Verdana"]

Backups can be performed while the database is in use, so you need not try and kick users off the database while taking a backup. However, since they are going...

[font="Verdana"]I personally, haven't used full text indexing much apart from when I had to rebuild it for a migration from 2k to 2k5. Where in the only thing you need...

[font="Verdana"]Is there any time constraint on this operation? Can you keep the users away for an extended period of time from the database? If that is possible then the below...

[font="Verdana"]

Here is a nice link, that has the query to do that. Please go through it carefully and see if it helps.

http://vyaskn.tripod.com/scripting_permissions_in_sql_server_2005.htm

Regards,

[/font]

For what object?

[font="Verdana"]For each database, only 1MDF will be in use. If additional datafiles are needed, they will have the extension NDF. You can have multiple log files(LDF). But, from your scenario...

[font="Verdana"]

kanejeeves (12/10/2008)

I must not be explaining myself correctly. I'm talking about within a single server, what do you do to support multiple releases? We too have 3 servers,...