Viewing 15 posts - 1,126 through 1,140 (of 1,219 total)
newbieuser (7/16/2013)
July 17, 2013 at 2:28 am
Put the statement in a stored procedure or user-defined functon. Sign the module with a certificate in master. Create login from the certificate and grant that login VIEW SERVER STATE....
July 16, 2013 at 4:23 pm
Why on Earth would you want to see the execution plan for that horrible procedure? When you have a loop, there will be plan for execution of a statement, and...
July 16, 2013 at 4:19 pm
From where do you have information that SQL 2014 would not support text/ntext/image? They certainly work in CTP1, and there is no information in Books Online, saying that they will...
July 16, 2013 at 4:15 pm
That sounds a little funny. But are those the complete statements? That is, there are no WHERE clauses?
July 16, 2013 at 4:04 pm
When 15000 rows have been loaded, someone trips on the network wire and the client is disconnected. With no BatchSize set, all 15000 rows are rolled back. With a batch...
July 16, 2013 at 3:58 pm
imransi17 (2013-07-16)
Thank you for the try but it gave me the following error 🙂similar to the on earlier...
The name RemoteServerName.DatabaseName.DBO.sys.sp_executesql is not a valid identifier
To whom was that in reply...
July 16, 2013 at 3:25 pm
You need bitwise or, that is the | operator, if remember the C# syntax correctly.
Then again, if there are queries running against the table, while your loading, they will be...
July 16, 2013 at 3:16 pm
If I understand correctly what you want:
DECLARE @sp_executesql nvarchar(1000)
DECLARE @sql nvarchar(MAX)
SELECT @sp_executesql =
quotename(@server) + '.' + quotename(@db) + '.sys.sp_executesql'
SELECT @sql = 'TRUNCATE TABLE ' +...
July 15, 2013 at 4:20 pm
Koen Verbeeck (2013-07-15)
SSIS is completely renewed, introduction of SSAS tabular and Power View, columnstore indexes, AlwaysOn Availability Groups, ...
OK, there is try_convert() too. As for improvements to SSIS or SSAS,...
July 15, 2013 at 3:10 pm
haiao2000 (2013-07-15)
July 15, 2013 at 3:06 pm
newbieuser (2013-07-15)
A network related or instance-specific error occurred while establishing a connection to SQL Server.The server was not found or accessible....
This has nothing to do with the versions of...
July 15, 2013 at 2:54 pm
Very good correct Lowell!
Here's one that is slicker:
EXEC LinkedServer.yourdb.sys.sp_executesql N'DROP USER myuser'
Not the least is this one slick, if any of the items are variable:
DECLARE @sp_executesql nvarchar(1024) =
...
July 15, 2013 at 2:47 pm
Jo Pattyn (2013-07-15)
Welcome Erland,About sql 2012, it is fairly new
It's been out for over a year...
and above all had its licensing changed (cores instead of cpu's)
Yes, the changed licensing...
July 15, 2013 at 1:57 pm
Viewing 15 posts - 1,126 through 1,140 (of 1,219 total)