Viewing 15 posts - 31 through 45 (of 50 total)
we get
Msg 15274, Level 16, State 1, Line 1
Access to the remote server is denied because the current security context is not trusted.
I presume this is because of the 'With...
April 14, 2009 at 1:11 pm
Found my answer. Needed set the 'RPC Out' on the Linked Server configuration to True, create a SP that will do the SELECT INTO on the remote Server. Call the...
April 13, 2009 at 3:28 pm
Good thought. The INSERT INTO works, but how does one create the table on the remote server first?
April 13, 2009 at 3:12 pm
Great Article, very powerfull, simple and low 'Black box' rating, unlike other apps.
For our automation, I have wrapped the Commandline version into a VB.NET program. The only problem we see...
March 24, 2009 at 7:32 am
it be nice if the code actually works. I get the same errors.
March 23, 2009 at 6:55 am
Works like a charm
Thanks Sunny!
February 11, 2009 at 12:12 pm
Thanks for your reply dbychen.
I am quite sure the database mail is configured properly. I was able to send a test message from it. I also did associate Operator. After...
February 11, 2009 at 11:37 am
DOS, Scripts, and SQLCMD; it still makes the world go around.
More beneficial is that wWhen troubleshooting occurs, this setup is readable every step of the way. I found this...
November 6, 2008 at 5:46 am
To move a table to another filegroup, simply pick a (numeric) column, or create a new rowID column and create an clustered index on one of those columns.
The procedure...
October 16, 2008 at 6:47 am
thanks Wayne!
We do data warehousing instead of OLTP and like the space savings associated with "set ansi_padding off". Is there a way that we can make it work and have...
October 7, 2008 at 2:00 pm
The attached code works beautifully, except we find that we can no longer use "SET ANSI_PADDING OFF" and must convert to "SET ANSI_PADDING ON", see error message below.
I like to...
October 7, 2008 at 12:59 pm
Nice article article Jamie!
Granter I am no master in SSIS, but I have used SSIS for several ETL type applications and when it runs OK, its great. Trouble is that...
July 4, 2008 at 7:14 am
Good article and seems to work for SQL2005.
I would add 1 statement to review available disk space
EXEC master..xp_fixeddrives
May 1, 2008 at 7:32 am
One could just save the Excel as a CSV file, load the file via BULK INSERT or OPENROWSET and be done.
Why go through hoops on and develop SSIS package?...
April 28, 2008 at 5:49 am
'Crash' means TCP network errors, due to maintenance or power fluctuations, that sort. That stuff happens when queries run a long time.
SQL logfiles running out of space...
November 28, 2007 at 5:32 am
Viewing 15 posts - 31 through 45 (of 50 total)