Viewing 15 posts - 106 through 120 (of 405 total)
If it is same server, it is good to use TSQL as Eric suggested. If it across servers, you can even use a data flow to leverage the SSIS pipeline...
June 6, 2016 at 7:41 am
What do you mean when you run the rebuild in local? Do you have a copy of the same database in your developer workstation/ laptop?
If that is the case...
June 6, 2016 at 7:18 am
Delete uses exclusive locks. Definitely tuning your where clause will help.
The dynamic SQL may give you a tough time though.
June 6, 2016 at 4:40 am
First, stop having negative thoughts, that will only harm you!
As Jeff pointed out, with a clear head, list out few things that you can work on and take some action.
Read...
June 6, 2016 at 3:45 am
ChrisM@Work (6/3/2016)
SELECT m.*FROM mytable m
WHERE EXISTS (
SELECT 1
FROM mytable i
WHERE i.cst_org_name_dn = m.cst_org_name_dn
AND i.mbt_code = 'EM')
AND m.mbt_code <> 'EM'
Yes. And if at all there are more possible...
June 3, 2016 at 8:14 am
Yup. Filestream supports only window authentication. But there is a workaround though.
http://www.sqlskills.com/blogs/bobb/using-filestream-streaming-io-and-sql-logins-with-impersonation/
June 3, 2016 at 8:02 am
John Mitchell-245523 (6/3/2016)
June 3, 2016 at 5:22 am
I cant find anything wrong in the function assuming you are using this in your catch block. How are you handling the catch for this insert. Are you getting any...
June 3, 2016 at 4:04 am
It is the name of the sheet in the excel, example if you have multiple sheets, each one of them can be accessed as a table individually.
June 3, 2016 at 3:25 am
From your first reply it looks like shared memory is not enabled. For connections connecting locally, SQL server must be using shared memory protocol. Have you tried enabling this?
June 2, 2016 at 5:23 am
A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible.
I think this clearly says the cant see the...
June 2, 2016 at 3:45 am
1) Are you able to access the database instance from a remote SSMS ?
2) Are you using any aliases in the SQL Agent Properties-Connection?
June 2, 2016 at 3:23 am
Is the browser service running?
June 2, 2016 at 3:03 am
Have you tried running the SQL Profiler?
June 1, 2016 at 11:09 am
Nice, catch, edited and added group by if at all OP is interested still.
May 31, 2016 at 5:52 am
Viewing 15 posts - 106 through 120 (of 405 total)