Viewing 15 posts - 5,716 through 5,730 (of 7,429 total)
Depends on the amount of data and exactly what you want to do.
You could if the databases are the same and you need to copy the data make a file...
May 28, 2002 at 8:49 am
There have been other threads about this and seems to be something with EM. Have you refreshed the view in EM and check thed other repositories. if still does not...
May 28, 2002 at 8:45 am
Scan counts should be as low as possible. As for Logical Reads, you want them to be as high as possible and more than physical reads is preferred (read from...
May 28, 2002 at 8:15 am
quote:
They will allow a maximum of 1 hour downtime, but there can be no loss of data.
May 28, 2002 at 6:08 am
I believe it is more of a timeout issue and could be related to blocking on the server. Check out the follwoing link for some information and try setting your...
May 28, 2002 at 5:23 am
A lite copy of Crystal Reports comes with VB.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 27, 2002 at 4:21 pm
Run the code thru QA a few times. For some reason the Oracle driver does not report the exact message every time. If you try a few times thru QA...
May 27, 2002 at 4:11 pm
If you are using SQL 2K I suggest use SCOPE_IDENTITY() instead. However, if this is based on every insert transaction I would consider using a trigger so you can catch...
May 27, 2002 at 3:58 pm
Sounds like the file (I am assuming this is a file device), may have a corruption issue. Try dropping and recreating it and see what happens.
"Don't roll your eyes at...
May 27, 2002 at 3:53 pm
Check out http://search.support.microsoft.com/search/default.aspx?Catalog=LCID%3D1033%26CDID%3DEN-US-KB%26PRODLISTSRC%3DON&Product=sql2k&Query=3241&Queryc=3241&withinResults=false&srchstep=0&KeywordType=PHRASE&Titles=false&numDays=&maxResults=25 should help you out.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 27, 2002 at 3:41 pm
DTS is easier exspecially when mapping the data. However to answer your secod question you would need to create a linked server to get the best results then TSQL can...
May 23, 2002 at 10:55 am
Try
INSERT INTO [product-summary] (columsntobeinserted) SELECT correspondingcolumns FROM [product-extract] WHERE shortsku NOT IN (SELECT shortsku FROM [product-summary])
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston...
May 23, 2002 at 10:49 am
Viewing 15 posts - 5,716 through 5,730 (of 7,429 total)