Viewing 15 posts - 376 through 390 (of 1,219 total)
Brian Seib (5/19/2015)
Yes - I do agree. This will give a good opportunity to free up some space as well with the full backup/restore method,
Not sure what your expectations...
May 19, 2015 at 10:44 am
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...
May 18, 2015 at 3:38 pm
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',...
May 14, 2015 at 3:13 pm
In the script you posted, you never added SHOP_REPORTING to the Reporting role, only a Windows user...
May 14, 2015 at 3:08 pm
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...
May 14, 2015 at 2:52 pm
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...
May 14, 2015 at 1:37 pm
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',...
May 5, 2015 at 1:03 pm
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
...
May 4, 2015 at 3:27 pm
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...
May 4, 2015 at 7:50 am
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...
May 3, 2015 at 4:02 pm
Gary Jillson (4/24/2015)
April 24, 2015 at 1:35 pm
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...
April 16, 2015 at 7:20 am
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...
April 16, 2015 at 6:23 am
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...
April 15, 2015 at 1:19 pm
David Rueter (4/2/2015)
Thanks, Eric.
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...
April 2, 2015 at 12:27 pm
Viewing 15 posts - 376 through 390 (of 1,219 total)