Viewing 15 posts - 7,201 through 7,215 (of 13,876 total)
Dhivya Elan (4/20/2016)
I have recently started using SSIS, and have been exploring various transformations trying to make the best use of them. I currently have a requirement where in,...
April 20, 2016 at 7:35 am
rafnunes (4/20/2016)
But correct if I'm wrong, after reset SQL server Service and application the lock should not disappear?
It's possible to know if a table is locked,...
April 20, 2016 at 7:31 am
singhamitpal (4/19/2016)
1.Very few developers will be able to create a consistent stored...
April 20, 2016 at 6:18 am
rafnunes (4/20/2016)
1 - Update 5000 rows with will be to extract, is a bit column with value NULL 0...
April 20, 2016 at 5:54 am
Eirikur Eiriksson (4/20/2016)
Phil Parkin (4/19/2016)
Ed Wagner (4/19/2016)
SQLRNNR (4/19/2016)
GilaMonster (4/19/2016)
And more homework in the forums. Is it wrong to want to post a sensible-looking but completely incorrect query as answers?Do it!
Are...
April 20, 2016 at 5:51 am
pvong (4/19/2016)
Jacob, I marked you as the answer because I learned how to do an error output file thanks to you suggesting it. Remember, I'm...
April 19, 2016 at 2:32 pm
singhamitpal (4/19/2016)
I’VE have been advised to stay away from the stored procedures meaning the business logic should NOT be stored in stored procedures, except where really really...
April 19, 2016 at 2:30 pm
John Rowan (4/19/2016)
Are you using the .ispac file for deployment?
I'm sure you know this, but ispac files get deployed only to SSISDB (as far as I know).
April 19, 2016 at 12:29 pm
Looks like you have two instances of the DB engine installed.
One will be accessible by typing 'localhost' in the server name.
The other will be accessible by typing [machine name]\SQLExpress in...
April 19, 2016 at 11:10 am
Ed Wagner (4/19/2016)
SQLRNNR (4/19/2016)
GilaMonster (4/19/2016)
And more homework in the forums. Is it wrong to want to post a sensible-looking but completely incorrect query as answers?Do it!
Are you thinking something along...
April 19, 2016 at 11:07 am
DSNOSPAM (4/19/2016)
Ok, went to control panel, found administrative tools, found servers, but nothing is giving me any version numbers.Trying to get an image or a list to post.
Services, not servers.
You're...
April 19, 2016 at 11:02 am
astrid 69000 (4/19/2016)
The code that Bill provided yes? and it it didn't work.I am reading the link he provided
and trying to work with that.
Saying that something "doesn't work" in the...
April 19, 2016 at 10:59 am
DSNOSPAM (4/19/2016)
I've...
April 19, 2016 at 10:57 am
astrid 69000 (4/19/2016)
thanks, but I don't understand what you are trying to do.
Did you run the code provided?
April 19, 2016 at 10:30 am
DSNOSPAM (4/19/2016)
Microsoft SQL Server 2005 - 9.00.5000.00 (Intel X86) Dec 10 2010 10:56:29 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 6.1...
April 19, 2016 at 10:28 am
Viewing 15 posts - 7,201 through 7,215 (of 13,876 total)