Ooh! Good point... However, I'm interested to see if there is a difference in permissions granted to this user...

You will be able to script the backup just as you script the attach. Simply create the database first with no tables, then restore the backup with a script:

USE master;

GO

CREATE...

ChrisM@Work (10/4/2011)

---

jared-709193 (10/3/2011)

---

ChrisM@home (10/3/2011)

---

Yes, several, but union (without ALL) would be best....

ChrisM@home (10/3/2011)

---

jared-709193 (10/3/2011)

---

PEOPLE!

If this query:

SELECT CHARINDEX('</t2>', data)

FROM TableName

WHERE CHARINDEX('</t2>', data) < 4

returns ANY data, (which it has already stated it does) the substring will fail every time on the...

This is a good idea. Can the user simply create...

ChrisM@home (10/3/2011)

---

Yes, several, but union (without ALL) would be best. Why do...

PEOPLE!

If this query:

SELECT CHARINDEX('</t2>', data)

FROM TableName

WHERE CHARINDEX('</t2>', data) < 4

returns ANY data, (which it has already stated it does) the substring will fail every time on the data set...

Just curious... Why aren't the DBAs doing the upgrades and installs? Unless you are not talking about SQL Server itself... I guess I am just confused. You have...

I think you are witnessing the reason that companies hire DBA's 🙂 As a DBA I routinely create databases and add the proper permissions. The reason we do not...

Lowell (10/3/2011)

---

it's pretty well documented that SQL will keep data for a TEXT datatype in a varchar(8000) as long as it's less than 8000 chars, otherwise it's stored a different...

EDIT: Removed previous quote as I quoted the wrong one...

DBAgal (10/3/2011)

---

jared-709193 (10/3/2011)

---

Also, SQL Server will return the error you are getting if even 1 row returns an invalid argument for...

Steve Jones - SSC Editor (10/3/2011)

---

DBA7: It's not "cannot", it's "does not".

Paul,

you are confusing the server level permissions with database permissions. Being able to create a database does not imply...

Hmm... There has to be another permission for this user that is not granted. Did you revoke any permissions?

Thanks,

Jared

If you don't mind using a temporary table, which can sometimes work very well and improve performance, you can do this:

SELECT c1, c2, c3, ..., cn

FROM T1

INTO #TEMP

GO

INSERT INTO #TEMP

SELECT...

I don't believe this can be done.

http://msdn.microsoft.com/en-us/library/ms189128.aspx

Thanks,

Jared