What is your default collation?

Well, I see you guys had a lot of fun here.

OK, I read this thread as well.

And I cannon figure out one thing.

Everyone agreed the puzzle was designed to...

UPDATE PP

SET Reference = m.NewRef

FROM Products PP, Mappings m

WHERE pp.Reference = m.OldRef

What in your rows groups them...

Once again.

It does not matter which order you use to insert data into a table.

In most cases it will be resided in the table in different order (depending on table...

vkres1 (8/3/2008)

---

Jeff,

I know you are every where. I am just catching up some ideas to post to different forums. some body was telling to try this query, I haven't tried...

You better don't use C:\ ever.

Giving users full access to C:\ folder on a server is not the bast idea.

Use shared folders or URL locations.

Are you sure folder C:\ on server USUARIO is open for writing for your user?

There are some notes which should help you to sort it out.

1. Your migration solution when finished to be applied to Production system where there are no new tables. So,...

This should work for you:

USE master

GO

IF EXISTS (SELECT name FROM sysobjects WHERE name = N'SP_AllIndexes_Properties' AND type = 'P')

DROP PROCEDURE SP_AllIndexes_Properties

GO

CREATE PROCEDURE dbo.SP_AllIndexes_Properties -- must be...

Francisco (7/30/2008)

---

I have a command file that was generated from a legacy system, the total size of the command file is 2gb, I have timmed out with the following error:...

I guess I've got it wrong 1st time.

This should be closer:

SELECT

u.Unit

, e.EquipmentDesc

...

Should it be something like this?

SELECT {WHATEVER}

FROM dbo.Unit u

INNER JOIN dbo.Equipment e ON ???

INNER JOIN dbo.Location...

How do you know that?

By running select COUNT(*) FROM NEW_TABLE ?

If so then COUNT(*)...

This should be really useful for you:

USE master

GO

CREATE VIEW INFORMATION_SCHEMA.Indexes

AS

SELECT O.Name as ObjectName, i.name, i.status, first, {whatever else you want to know about indexes}

FROM sysobjects O

inner join sysindexes i...