Viewing 15 posts - 1 through 15 (of 54 total)
Thank You
I will try this with @Execute = 0
Thus database is big old and ugly
Thanks again
May 17, 2012 at 12:55 pm
Thanks do you use this how long does it take to run(how many tables do you run it on) and do you run it while users on on the database.
May 17, 2012 at 11:59 am
I created another table that look like these
SETID INV_ITEM_ID MFG_ID MFG_ITM_ID PREFERRED_MFG
CORP1 0031 800281 0031 Y
CORP1 0031TM 800281 0031TM Y
CORP1 0032 800281 0032 Y
CORP1 0051 800281 0051 Y
CORP1 0051SP 800281 0051SP Y
CORP1 0052 800281 0052 Y
CORP1 0061 800281 0061 Y
CORP1 0062 800281 0062 Y
CORP1 0071 800281 0071 Y
CORP1 0072 800281 0072 Y
It has 3000 rows and I want to update it's sister table but only where the inv_item_id is in the master_item_tbl...
April 11, 2012 at 2:07 pm
the 3000 rows are in an excel spreadsheet that I was emailed to insert in to my two tables(3000 for each table 6000 total)
I will copy these into studio and...
April 11, 2012 at 12:30 pm
This is my whole statement the convert I use gets me an error of
"The conversion of a char data type to a datetime data type resulted in an out-of-range datetime...
April 10, 2012 at 12:51 pm
2008-07-02 17:31:12.000
the overall database size is 300gig and I fear that maintenance of any kind has not been run on it since 2008
backups take 15 hours.
March 8, 2012 at 2:08 pm
Thanks Guys I did the Select INTO which worked much better than the EXPORT and I deleted 1000 rows at a time with a delay in between and had maybe...
March 6, 2012 at 7:17 am
Worked perfectly with no trouble at all thanks
February 7, 2012 at 7:05 am
Thanks You very much
I will try this tonight.
February 6, 2012 at 2:21 pm
Thanks You very much
I will try this tonight.
February 6, 2012 at 2:14 pm
If I run it on the production database I wont to remove the extra logfile from I get.
status =0 on all????
FileId FileSize ...
February 6, 2012 at 2:00 pm
if I DBCC loginfo from the master I get
FileId FileSz Start FSeqNo Status Parity CreateLSN
2 253952 8192 27923 0 128 0
2 262144 262144 ...
February 6, 2012 at 1:38 pm
the detach sounds like it my cause a lot of problems I have a very small windows to do this move in as we run 24/7 I need it...
September 2, 2011 at 12:40 pm
then I would set the database off line and copy to the new location and bring online? If copy fails then I could just reset sql back to old location.
September 2, 2011 at 11:31 am
Viewing 15 posts - 1 through 15 (of 54 total)