Koen Verbeeck (5/25/2012)

Schadenfreude-Mei (5/25/2012)

Koen Verbeeck (5/24/2012)

As long as you keep all those grunge...

do you want a script which checks each databases to see if a particular login has been granted user access to the DB?

When a database is attached to SQL, the sqlserver.exe locks the files so that it has exclusive access to the files, the only way to backup databases via NetBackup without...

SQL 2000 is DTS not SSIS, are you sure its SQL 2000 or is it SQL2005/2008?

What coding issues are you facing?

Rebuild master just rebuilds the master database, but to be...

lookup the merge syntax in BOL or Google, its basically a fancy update/insert/delete combine statement, based on what you want, the main bits are the WHEN MATCHED and WHEN NOT...

the merge command will do what you need to do

when not matched by target = insert

when not matched by source = delete

when matched and target.col1 <> source.col1 or target.col2 <>...

Merrie Melodies

roadrunner (beep beep)

No problem, happy to help as always.

Only SQL authentication accounts become "orphaned" this is due to the SID's being different on Server1 to Server2. The exception to this is if the SQL accounts have been...

It's a seperate check box on the SQL Server installation, so you will need the SQL Server media to install BIDS. Its a completly seperate program from SSMS.

The installation...

When you install SQL you have the option to install what we call BIDS (business intelligence development studio), if you dont have it installed, just simply run through the media...

You would need to build in a dynamic date call something like the below

declare @datestamp nvarchar(30), @cmd nvarchar(max)

set @datestamp = REPLACE(REPLACE(REPLACE(CONVERT(NVARCHAR,CURRENT_TIMESTAMP,120),'-',''),':',''),' ','')

set @cmd = 'BACKUP LOG db1 TO DISK =...

Something like this

DECLARE @toemail varchar(150), @jobname nvarchar(150), @short_desc nvarchar(150)

DECLARE email_cursor CURSOR FOR SELECT email, RTRIM(Job_name), RTRIM(short_desc) FROM vw_expiring_jobs

OPEN email_cursor

FETCH NEXT FROM email_cursor

INTO @toemail, @jobname, @short_desc

WHILE @@FETCH_STATUS = 0

BEGIN

PRINT @toemail

DECLARE @body...

What is the business requirements on changing the server level collation? Is there a specific problem you are attempting to fix?

Rebuilding the master DB will result in all the...