Not sure what your expectations...

Rather than starting the server in single-user mode, which is bound to cause grief, disable TCP/IP and named pipes and run all from SSMS on the server.

Or set all databases...

Actually members of securityadmin can do anything I believe, as it is in their powers to elevate themselves to sysadmin...

That aside, let's try it:

CREATE CREDENTIAL credo WITH IDENTITY = 'ident',...

In the script you posted, you never added SHOP_REPORTING to the Reporting role, only a Windows user...

I did not look closely enough at the original post. The fact that the view is in a different schema than the table does not matter as such. But the...

How many times do you get the error message? You should get it once, since you run a query against the base table as well.

If you get it twice, there...

Indeed you can. You can have multiple CROSS APPLY on nodes that relate to each other:

SELECT

testsuite.c.value('@name', 'nvarchar(20)') as testsuitename,

tescase.c.value('@internalid', 'int') as testcaseid,

testcase.c.value('@name',...

Is this what you are looking for:

DECLARE @xml XML =

( SELECT * FROM OPENROWSET(BULK 'C:\temp\test.xml', SINGLE_BLOB) AS data)

SELECT @xml c1 INTO ttt

select c1 FROM ttt

SELECT

...

And the XML document made it to the table?

And more importantly, did you ran the code that I posted, with the XML file you submitted as C:\Temp\test.xml? Or did you...

Not sure what your problem is. I was able to run your code, with two modificiations. The column should be c1, and since the name is an attribute that should...

Gary Jillson (4/24/2015)

---

I have DB test1. The DB dbo user login is domain\user1. User1 is also part of a security group which has public, datareader and datawriter access to the...

You need to install it on the SQL Server instance. There is no need to embed in the app. Unless, that is, this is an app that you install at...

Googling on xp_rsa_load_key I get a lot of hits on xpcrypt.com. To register the DLL, you use sp_addextendedproc. However, most likely you cannot take the DLL from the SQL 2000...

What do you mean with "temp table"? The normal understanding of the term is a table of which the first character is a hash mark, e.g. #temp. These tables are...

Eric?

So it sounds like there is not a way to have ownership of created objects automatically assigned to the user that creates them. That's too...