And watch out for events that might only occur Monthly or Quarterly etc.

Hi

When you right click on the table to generate a script there are three tabs

General -- Formatting -- Options

Click on options and there you can tick script indexes...

In Enterprise Manager expand your database and choose tables. If you want to copy more than one table hold down the shift key and use your arrow keys to highlight...

Good for him! But I hope he still has a job. 

Hi

The drive must be mapped under the user profile that SQL Server runs on.

TRY THIS.......

CREATE PROCEDURE getKeyField

@tableRef sysname

AS

SELECT constraint_name FROM

INFORMATION_SCHEMA.TABLE_CONSTRAINTS (NOLOCK)

WHERE TABLE_NAME = @tableRef AND CONSTRAINT_TYPE = 'PRIMARY KEY'

exec getKeyField 'TABLENAME'

I do not have a solution like that but bear in mind the SQL Server has the very best tools for importing multiple source types. Look at the DTS Packages.

To place an existing table on a different filegroup (Enterprise Manager)

• Expand a server group, and then expand a server.

• Expand Databases, expand the database in which the table belongs,...

The reason for Going 64bit was simple. My 32bit machines are not coping anymore. And I am preparing my hardware to make the most of Yukon when it ships.

Thanks for the reply Larry.

At least I am not the only one with this disparate architecture. I might give you a mail when the 64bit partition...

Adding a column in a hurry without doing checks!

Been there! Done that! and will NEVER DO IT AGAIN! It can cause total destruction...

Hi,

One of the causes for this is that the Oracle datatype number can have a very large precision data type, that is too large for vbscript to handle. (Its actuly...

Hi,

I really hope that I have not TOTALLY missed it.

Are you using Query Analyser? If so are you using "Query results in Text"?

Change the Query Analyser to return the results...

Frank

I have already saved the script in my "KEEP - will need some day" safe place.

Yes it works - I have just tested it.

Hi,

I was typing a response that says exactly the same as Frank's replay. You have to use an extended sp if you wan't the actual IP.