Viewing 15 posts - 1 through 15 (of 136 total)
You're getting the errors because the temp tables already exist. I can see the lines further up where they are supposed to be dropped, but they are remarked, so...
November 16, 2015 at 11:13 am
I forgot to add that pietlinden wasn't talking about using SSIS. If you have linked tables you won't need SSIS. It's very useful but has a bit of...
May 15, 2015 at 12:34 pm
A linked table in Access is a table object which doesn't reside in Access, but exists somewhere else and is linked to the Access table objects. It sounds complicated...
May 15, 2015 at 12:32 pm
Take a look at 'sp_columns' (for tables) and 'sp_sproc_columns' (for stored procedures) in BOL. Both are system stored procedures and they might be what...
May 15, 2015 at 12:04 pm
Have you tried opening the 2000 d/b with Access 2013? It might just convert the old format automatically although I'm not sure if the later version will go that...
May 15, 2015 at 11:53 am
Very elegant solution.
May 5, 2015 at 12:49 pm
Offshore developers...whaddya gonna do? :Whistling:
May 1, 2015 at 11:08 am
I always say yes when the boss is handing out free training. It may not be immediately applicable but learning new things is always a good thing. Keeps...
April 27, 2015 at 12:12 pm
No we don't do code reviews in a formal sense. These days the excuse is 'not enough time' but I think that's shortsighted. I have learned the...
April 24, 2015 at 7:34 am
What kind of an alert do you want? An email would be great here, but the message is that you can't send an email due to lack of...
April 23, 2015 at 1:02 pm
Search the forums for 'interview questions' or 'interviewing'.'
I know I've seen several discussions of this over the years.
April 23, 2015 at 12:16 pm
Patrick Cahill (4/23/2015)
Bill Talada (4/23/2015)In my opinion, a DBA that isn't generating most stored procedures is wasting their life on ugly details.
Bill Talada (4/23/2015)
I couldn't disagree more. Our developers are...
April 23, 2015 at 10:12 am
Not much to go on, but ...
If you run this:
SELECT * FROM OPENROWSET(BULK N''' + @fullPath + ''', SINGLE_BLOB) AS x
Does it run silently or do you get an error?
April 22, 2015 at 12:22 pm
Go to Books Online and read up on the DatePart, DateDiff and DateAdd functions and how to use them to take apart DATETIME columns.
Also look at Lynn Pettis' ...
April 21, 2015 at 2:18 pm
You'll need to write an INSERT trigger on the Stage table. Any time a record is inserted into a table, there is a system recordset called INSERTED that is...
April 21, 2015 at 2:07 pm