Viewing 15 posts - 48,616 through 48,630 (of 49,571 total)
PinAnt
Could you post the structure and data your two original tables and what you want as a result.
June 21, 2007 at 6:45 am
I assume the FileID is the identity column. Try this for the insert statement.
insert wms_TrnRecoveryDetails ([User_ID],[FileName], FileModifiedDate, Filesize, system, Bookid, stageid, Divisionid, wmsid, Activityid, jobcode)
values (@User_ID, @Filename, @FileModifiedon, @Filesize, @System,...
June 21, 2007 at 5:05 am
Check the server name and check the login name being used.
That message usually means that the server name specified is not a running sql server or that the login...
June 18, 2007 at 1:31 am
Possibly due to security. When you run the package manually, it runs under your credentials. When its scheduled it runs under the service account of SQL Agent.
It could be connections...
June 15, 2007 at 1:15 am
Wouldn't need any scripting.
Set up snapshot replication from the 2005 machine to a 2000 machine. Snapshot copies the entire database across, structure and data. Then back that 2000 database...
June 14, 2007 at 8:29 am
Here's a way out idea.
How about replication to a 2000 server that you control? Then you can take a backup of that and send it off. Even if you just...
June 14, 2007 at 7:42 am
The underlying structure of the code to create the databases is basically the same.
The code may be basically the same, but the structure of the database, specifically around the system tables...
June 14, 2007 at 3:50 am
What's the server's collation and what's the database's collation?
You can get these errors wen those two are different and a temp table is used, or a query uses a worktable...
June 14, 2007 at 2:09 am
What's the error you get?
June 12, 2007 at 4:19 am
What are the specs of the prod and dev servers? how much memory is allocated to SQL on each of them? Is there anything else running on those servers?
I'd run...
June 12, 2007 at 4:10 am
What are you trying to create an endpoint for?
According to Books Online, the syntax for a TSQL endpoint is
CREATE ENDPOINT endPointName [ AUTHORIZATION login ]
[ STATE = { STARTED | STOPPED...
June 12, 2007 at 2:33 am
I'll dig into schemas, if I get a chance. See if I can figure anything out. XML is not something I've worked much with though.
June 12, 2007 at 12:01 am
I would advise against automating a kill script. I've been in that situation. Best thing is to resolve the cause of the problem, not to have an automated process to...
June 11, 2007 at 11:59 pm
2) Use of both distinct and union - each require tempdb and sorting --> inefficient.
the optimiser is smart enough not to do both. In cases I've seen like this there's...
June 8, 2007 at 7:56 am
If you have a deadlock, SQL's own internal deadlock detector will detect the deadlock, pick a victim and kill that connection. You don't have to do anything.
Or are you talking...
June 8, 2007 at 2:52 am
Viewing 15 posts - 48,616 through 48,630 (of 49,571 total)