Should be *without*

When you export data via SSMS, you have the option to choose a text qualifier. I believe the default is the double quote. All this does is wrap all...

Adam... just so you know, that function doesn't actually work... it returns a zero for positive numbers AND returns a "domain error" if @NBR happens to be a zero...

DECLARE @NBR...

Yes. There is no problem in...

Agreed.

I have exhausted every other solution. The only place the stored procedure can be and still...

In SQL 2005 the best way is to ,take the database offline, then move the respective data/log files to desired location, then update the new location of the database...

This one is better as it does not use the depreciated sys.logins but uses the new DMVs.

EXEC master..sp_MSForeachdb '

USE [?]

DECLARE @username AS VARCHAR(25), @Counter INT, @NbrLogins INT

SET @Counter = 1

SET...

Ok here is the script. I would highely recommend that you put a filter on the where clause, so you do not grab system accounts or built-in accounts. ...

Make sure you have the right database selected in the drop down. If you have the correct database highlighted when you open the file; SSMS will default the connection...

Double click on the .sql file. This will open the file in SSMS then all you have to do is click the execute button 😉

I finally got around to testing it with a test db. I have tested the above code and it is wokring as intended.

This final bit of code should work for you. Note that you will want to make sure the user is in the database first. Your final code will...

Its because the set is outside the execution of the loop move the set = username in the loop.

EXEC master..sp_MSForeachdb '

USE [?]

DECLARE @username AS VARCHAR(25)

SET @username = ''test''

IF ''?'' <>...

declare @username as varchar(100)

declare @runcommand as varchar(100)

SET @username = 'test'

EXEC master..sp_MSForeachdb '

USE [?]

IF ''?'' <> ''master'' AND ''?'' <> ''model'' AND ''?'' <> ''msdb'' AND ''?'' <> ''tempdb''

BEGIN

EXEC sp_addrolemember N''db_datareader'',...

What is your error?