Viewing 15 posts - 4,801 through 4,815 (of 5,094 total)
You need to change the default for SSMS 2016. The fact that your changed 2012 won't have any affect, as they are two distinct Applications.
Locate your SSMS 2016 Installation folder...
November 14, 2016 at 6:34 am
This all depends on how you want it set up, but is fairly easy.
I'm going with an assumption, right now, that you want your users to be able to navigate...
November 14, 2016 at 5:00 am
Robin35 (11/1/2016)
John Mitchell-245523 (11/1/2016)
November 1, 2016 at 8:45 pm
Glad to see my brain is still working, even after waiting 2 hours for my flight, with another 4 to go! I was pretty sure it had given up when...
November 1, 2016 at 2:26 am
November 1, 2016 at 2:23 am
"Frame" possibly wasn't the beat choice of word sorry (what I get for poking in Web Dev recently). I mean that you use an object which has a grouping on...
November 1, 2016 at 1:46 am
If you wish to use a SQL Login, and haven't set these up, you need to define these settings. You can find them in your Server Objects, Linked Servers, then...
October 31, 2016 at 1:40 pm
Is Server1 the Server that is running the job? You should really be using a real account, rather than default if you need to authenticate to other areas of your...
October 31, 2016 at 10:40 am
Seems like you don't have the login credentials set up correctly for the user running the agent task, as it's trying to authenicate to the other server as Anonymous.
Does the...
October 31, 2016 at 9:58 am
If I'm reading your SQL right, you're declaring a Parameter/Variable as a Table name "FROM ?". This won't work. A parameter needs to be a parameter.
If you need to use...
October 31, 2016 at 8:30 am
I therefore assume your SSIS package SQL task is expecting a Single Row Result set then?
COALESCE (T-SQL) would work for you then.
Edit: Added link.
October 31, 2016 at 8:13 am
Why not use COALESCE around the SELECT statement? Why is it in a sub query, instead of in the FROM clause?
October 31, 2016 at 8:04 am
Rechana Rajan (10/31/2016)
Sue_H (10/27/2016)
I usually see them with apps that are using SqlDependency and service broker.Sue
Thanks Sue.
Can i delete those procedures? Its creation date is showing 1 year old.
Just...
October 31, 2016 at 5:32 am
Although format is easy, if you're applying this to a dataset, I heavily recommend against it. You'll find it to be incredibly slow.
October 31, 2016 at 5:25 am
October 31, 2016 at 4:43 am
Viewing 15 posts - 4,801 through 4,815 (of 5,094 total)