As far as the conversion, you need a valid date, no matter what the format. If there is '00000', this isn't remotely valid.

What you can do is look for...

Only for convention. These are just file names and extensions, no relation to how SQL Server uses the files.

Your description is not clear about what you are looking for. What dependencies? What are you expecting the stored procedure to do?

What does filter mean? Are you looking to return this in a report or delete the data?

If duplicates, the distinct keyword can help you in a query to only show...

I believe the limited information for these is sysobjects in SQL 2000. There were many fewer system views in SQL 2000.

Moved to SQL 2000

I would use two roles here. One to read only from old tables, one to allow DDL activities.

If someone can create tables, they will be able to read/write from...

I believe that you would need to use dynamic SQL, to create the database.

declare @cmd varchar(max)

select @cmd = ' create table ' + @newdb + '.dbo.mytable (myid int)'

exec (@cmd)

Here's the bigint doc. You'd need to compare it to the Oracle documentation

http://msdn.microsoft.com/en-us/library/ms187745.aspx

If you get a PK error, then you have a PK update occurring.

What I would do is change this to a SELECT, and pull out the PK columns from...

Roy Ernest (12/13/2010)

---

Brandie Tarvin (12/13/2010)

---

Wow. I just had the worst time trying to post to Grant's blog. Three times I had to try before my post went through.

You'd think he...

Tom.Thomson (12/12/2010)

---

Yes, it changes now...

Excellent response from Lowell and Gus.

Tom, new avatar?

I've used them, often as a base maintenance setup for systems that aren't stressed or critical. They have worked fine.

However when I need finer control, I tend to use custom...

Craig Farrell (12/10/2010)

---

Steve Jones - SSC Editor (12/10/2010)

---

Craig Farrell (12/10/2010)

---

I'm failing to see the problem with this... I'd purposely go out of my way to wander through said lounge on...

Jack Corbett (12/10/2010)

---

I understand both the fact that's it's not a highlight and, especially, the travel part. I just want to encourage everyone to give it a shot as...