Viewing 15 posts - 946 through 960 (of 1,583 total)
SQL 2005 or 2008?
If 2005, in the Surface Area Configuration application, check the Connections, then Remote Connections section, then check to see if you have Named Pipes and TCP/IP connections...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 28, 2012 at 5:25 pm
Please post the TSQL that you've come up with thus far
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 28, 2012 at 5:19 pm
For kicks and giggles...what happens when you actually include all the columns in the OPENQUERY:
Ex:
INSERT INTO table
SELECT [TableKey1],[TableKey2],[TableKey3],[Column4],[Column5],[Column6],[Column7],[Column8],[Column9],[Column10]
,'','','','','','','','','','',0,''
FROM OPENQUERY(server, 'SELECT TableKey1,TableKey2,TableKey3,Column4,Column5,Column6,Column7,Column8,Column9,Column10
FROM providerstring.library.table')
I also would wager that this would work as...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 28, 2012 at 5:14 pm
You mention that the 4-part SELECT still works (without error), but does it still work in conjunction with the INSERT?
INSERT INTO table
SELECT * FROM server.providerstring.library.table
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 28, 2012 at 12:08 pm
Are you 100% certain the schema is identical from ServerA - ServerB - this also means, there are no computed columns on this new server that's generating the errors?
It would...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 28, 2012 at 11:00 am
I always assume those steps are performed before someone even posts to the forum :w00t:
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 28, 2012 at 8:44 am
So, at least I know that permissions are ok. Drive where UNC folder is 1TB. Total table size is less than 70 GB. So, we have plenty of space. we...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 28, 2012 at 8:43 am
I don't believe this is possible. You could however run the statement below using linked servers to connect to each of the servers, that could give you what you...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 28, 2012 at 8:31 am
I know this contrary to what everyone else has said but I've experienced similar behavior when a RAM module was going bad. Everything seemed fine until either the connections...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 28, 2012 at 8:03 am
You definitely have some issues with the data in your MSDB table.
I'm pretty certain the reason your backup completes successfully but your maintenance plan job fails is because you have...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 27, 2012 at 2:25 pm
As long as your client authenticates via VPN into your network, they will be granted and assigned a local IP address on your domain...they will have all the rights that...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 27, 2012 at 12:00 pm
OP, please click here
:hehe:
Edit: I believe the actual error is SSPI Context, not content
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 27, 2012 at 10:21 am
I've got a suggestion but first need to know how large is your publication? For instance, how many articles are in this publication? A few dozen? Hundreds? How long...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 26, 2012 at 2:59 pm
The agent job will be wherever your distributor resides
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 26, 2012 at 1:52 pm
What kind of replication are we talking about? I assumed it was transactional...and if you restarted the snapshot agent it would have automagically resnapped the entire table and everything...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 26, 2012 at 1:28 pm
Viewing 15 posts - 946 through 960 (of 1,583 total)