Viewing 15 posts - 6,166 through 6,180 (of 9,401 total)
Like Gail pointed out, the error is saying it can't open the explicitly defined database. The connection is made, but look in the connection string for the initial catalog....
April 28, 2015 at 6:12 pm
Koen Verbeeck (4/28/2015)
Lynn Pettis (4/28/2015)
firstly id like to apologies for being hasty, but i am under a lot of pressure as this is due for my finals on thursday,
Ouch :rolleyes:
So...
April 28, 2015 at 1:41 pm
Sorry, without having DDL, I just created a CTE to simulate the table. If you substitute it like Lynn did, you'll be all set.
April 28, 2015 at 10:44 am
Just because I'm someone who doesn't like cursors, I feel compelled to offer an alternative.
DECLARE @strSQL Varchar(MAX) = '';
WITH FinalDBleverluser(dbname, username) AS (
SELECT 'db1', 'user1' UNION ALL
...
April 28, 2015 at 10:17 am
Revenant (4/28/2015)
SQLRNNR (4/28/2015)
TomThomson (4/27/2015)
SQLRNNR (4/27/2015)
marlinspike
hall
fame
Fortune
April 28, 2015 at 10:08 am
Eirikur Eiriksson (4/28/2015)
crookj (4/28/2015)
Ed Wagner (4/28/2015)
djj (4/28/2015)
Eirikur Eiriksson (4/27/2015)
TomThomson (4/27/2015)
SQLRNNR (4/27/2015)
marlinspike
Top
Apex
Predator
Alien
Immigrant
Legal
April 28, 2015 at 7:33 am
djj (4/28/2015)
Eirikur Eiriksson (4/27/2015)
TomThomson (4/27/2015)
SQLRNNR (4/27/2015)
marlinspike
Top
Apex
Predator
April 28, 2015 at 5:13 am
With 87% getting it right at this point, that's encouraging. I guess I just took knowing that for granted and never gave it a second thought. It's always...
April 28, 2015 at 5:09 am
SQLRNNR (4/27/2015)
Lynn Pettis (4/27/2015)
Ed Wagner (4/27/2015)
Grant Fritchey (4/27/2015)
Hey Steve! Where did you get pictures of my cousin?I never thought of you as having a strong feline side. 😀
How many people...
April 27, 2015 at 2:03 pm
Eirikur Eiriksson (4/27/2015)
eccentricDBA (4/27/2015)
SQLRNNR (4/27/2015)
marlinBrando (his fishy cousin)
The horror
The Pain
April 27, 2015 at 1:26 pm
djj (4/27/2015)
Eirikur Eiriksson (4/27/2015)
Ed Wagner (4/27/2015)
Revenant (4/27/2015)
TomThomson (4/27/2015)
Eirikur Eiriksson (4/27/2015)
Ed Wagner (4/27/2015)
djj (4/27/2015)
CopperCanyon
Crossing
Out
Outhouse
Doghouse
Hut
Pizza
Wings
April 27, 2015 at 11:21 am
Grant Fritchey (4/27/2015)
Hey Steve! Where did you get pictures of my cousin?
I never thought of you as having a strong feline side. 😀
April 27, 2015 at 11:20 am
neeraj-344433 (4/27/2015)
It is a nightly ETL job. Once the data is loaded in the staging table, the process picks it up and loads into other system.
That's the 16-hour run you...
April 27, 2015 at 10:56 am
You have a table with 85 columns and 3M rows. Do you need to query all of them every time?
April 27, 2015 at 10:48 am
Brandie Tarvin (4/27/2015)
Lynn Pettis (4/27/2015)
Ed Wagner (4/27/2015)
Lynn Pettis (4/27/2015)
April 27, 2015 at 10:40 am
Viewing 15 posts - 6,166 through 6,180 (of 9,401 total)