Welsh Corgi (1/21/2013)

---

Thanks. Not sure why I'm getting an error on the substring function.

Msg 8116, Level 16, State 1, Line 1

Argument data type numeric is invalid for argument 1 of...

Welsh Corgi (1/19/2013)

---

I'm haveing trouble with a simple CAST to VARCHAR Statement.

SELECT

CASE WHEN CAST(LEFT(Customer.STARTDATE, 2 AS VARCHAR(2)))

...

Why use all those substrings anyways?

declare @TestData table (

AS400Dates VARCHAR(10)

);

insert into @TestData

VALUES

('0991231'),

...

sqlfriends (1/20/2013)

---

The thing I found on a dev server, the database developer has all the rights on the box

and when he runs the build script sometimes, it accidently goes to...

I'm curious what the business case is for reseeding the identity value? What problem is this solving?

And you couldn't take 5 minutes to...

faisalfarouqi (1/19/2013)

---

Thanks. a lot once again, and really do appreciate what you guys say. I'll try to figure out how best I can utilize the info provided by "sestell1". Pls....

Well, that leaves me out as I have nothing at hand and I am not going to take the time to try and write something, especially since I don't have...

faisalfarouqi (1/19/2013)

---

Thank you guys, but frankly speaking I kind of need a general script which can be run by changing some parameters, and then it should loop through all linked...

Nope.

Are the date representations integers or characters? How is a date in 1999 or earlier represented?

Also, it would be nice if you presented your informatioin the way you advocate...

Details, how is MSDTC configured on both systems. It has been 5 to 7 years since I had to deal with this issue so I don't have complete memory...

Also, since this appears to be a heap table, if there are a lot of inserts and deletes SQL Server will not reuse the space in the table created by...

I don't know if what Sean provided you helps or not. My problem is I can't figure out what it is you are trying to accomplish. Some of...

Shrinking the database, bad idea, especially if it is done after the index rebuild. Index rebuild rebuilds the statistics for the index. You should have a process the...