The data is stored in an image column as a varchar string (not my design, not something I can change).

I pull it out, converting it to varchar, into a varchar...

Thanks. That (and some googling) showed me something very useful for future reference.

Unfortunately, that function didn't help in this instance, as it only made things far worse (since it...

What is "Tally.N" in that function?

I use this one-off script for similar things... not as formalized as Lowell's stored proc, but I just pull this up in SQL Server Management Studio, edit it to specify...

jared-709193 (10/4/2011)

---

Ok, I just did some testing. I believe that the login you are using to attach/restore the database was never given access to the original database 🙂

Attach/restore the file...

I've assumed this schema:

CREATE TABLE computers_deviceprocessors (id int PRIMARY KEY, computer_id int, deviceprocessor_id int)

CREATE TABLE deviceprocessors(id int PRIMARY KEY, number_deployed int)

...and this sample data:

INSERT INTO computers_deviceprocessors (id, computer_id, deviceprocessor_id)

VALUES (1,...

You can very easily generate SQL to do the updates, to save you a lot of typing. You can whip up something like this very quickly:

SELECT 'UPDATE [Name] SET...

george sibbald (10/4/2011)

---

ok, now I am confused. Are you using a SQL authenticated account?

If I try and do this with a SQL account that does not have sysadmin rights I...

I don't know if this will help, but this is the script I coded to shrink stubborn log files... this can recover a lot of space:

DECLARE @file sysname

SELECT @file=[name] FROM...

In addition to above... if you're not on the same sever as the script, you'd need to use the \\machine-name\share notation. For example, to make c:\Data\data.txt available to...

No, it's all case-insensitive. It's an older database. It just struck me as really weird that no matter what I did, I kept getting the error. Go...

jared-709193 (10/4/2011)

---

Ok, I just did some testing. I believe that the login you are using to attach/restore the database was never given access to the original database 🙂

Attach/restore the file...

jared-709193 (10/4/2011)

---

I think that part of the issue here is that attaching or restoring is bringing in the database users with it. When you do this from 1 instance...

No dice.

The "restore" process mucks with the NTFS security descripter just like the CREATE DATABASE FOR ATTACH does.

Got a great script working to restore from backup, and once the DB...

When I USE the database, and try to run the stored procedure, I get this:

Could not find stored procedure 'sp_AddRoleMember'.

If I open...