I think this way is better:

SET XACT_ABORT ON

BEGIN TRY

BEGIN TRAN

CREATE CLUSTERED INDEX ix_TableA_Transfer ON tableA (id) ON [PRIMARY]

COMMIT

END TRY

BEGIN CATCH

ROLLBACK

END CATCH

Here is what I use. I create or rebuild de cluster index or primary key within a transaction to protect the integrity of the table in case of failure:

SET XACT_ABORT...

Wow, I just hit the ground hard!!

Excelent!!

Alberto

Gail, what happens when, after monitoring your data growth for years, you discover that it only fills a little percentage of the datafile, and you are getting short of disk...

nchar(1) is the one. I agree with all explanations above.

Alberto

Hi:

Server roles in SQL Server are fixed, you can't create, modify or delete a server role.

Check theese:

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

http://www.sqlservercentral.com/articles/Administration/sqlserversecurityfixedroles/1163/

In the Other hand, you can create new Dataase Roles:

Hi:

This is a common practice in datawharehousing. That smaller key is named subrogated key. You can save space, yes. But I think that's not the main purpose of it. Normally,...

or here:

http://msdn.microsoft.com/en-us/library/ms191524(SQL.90).aspx

Alberto

Start here:

http://msdn.microsoft.com/en-us/library/ms178110(SQL.90).aspx

Good luck.

Alberto

It looks like the problem is about security. You allready had some advice about firewall settings. Take a look to the Security Settings in the linked server properties:

You can use...

Hi, If the table is in a different instance or server, you first need to configure a linked server, and write the following statement:

Insert into dbo.LocalTable (LField1, LField2, LField3)

Select (RField4,...

If you have Office 2007 Pro there's a new tool called Infopath to make forms.

Good Luck

Try using Linked Server instead of Openrowset, it's kind of slow but it worked for me

NOTE:

--I've tried this with Excel 2003, not 2007

--Its kind of...

ALELUYA!!

thanks a lot

Alberto

Hi Steve:

I can get into forums with specific URL, but when I call http://www.sqlservercentral.com I'm still getting this message:

ZoneEdit DNS services for this domain have expired.

To reactivate service...