I would go with option 2. Overall there is les chance that other transactions will interfere with other customers and you can spread the data across more drives as you...

Dropping and creating should cause SQL to use correctly. This could be a bug. What Service Pack is installed and if not the latest have you tested to see if...

If you need to set values of parameters then you need to use a linked server as described otherwise you can use OPENROWSET or a linked server with OPENQUERY. If...

Does your Access project utilize a workgroup file? If so you will need to set it up like you would on any other machine so that the Access registry is...

There are plenty of issues surronding parallelism and the fact it tends to suffer at this point primarily for inconsitent data output for various reason (many have been fixed but...

Check the scripts created by Power Designer and see if anything is unusally in how they are copied. Could be moving to the table directly and not issuing an alter...

You could add a step via the job to verify how many instead are in the folder and with active script delete the oldest instead of expiring. BUt you have...

As far as I know we are not. I will double check to be 100% sure, but I don't think that the database owner is an issue. I beleive the...

It may have a good reason but the best way to find out is to compare the execution plans and see what is different between them.

Use openquery instead.

SELECT * FROM OPENQUERY(LSERVER,'SELECT * FROM dbfcustomers')

Access is one of those that the four paert naming convention does not apply. Also, I am not sure as not test...

Duplicate post, see additional responses in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=8535&FORUM_ID=23&CAT_ID=2&Topic_Title=Leading+Zeros&Forum_Title=General

That is most likely an average. Unfortunately I did not attend but I am familiar with Identity and how it works. It has to place a lock on the storage...

If you need to present with a specifc length with leading 0's then I do as follow.

REPLICATE('0',overalllength-LEN(CAST(numericcol AS varchar(overalllength))) + CAST(numericcol AS varchar(overalllength))

Otherwise no leading 0's on numerics and it...

Yes, it is a newer product and the documentation is quit limited to only MS MSDN library and the documentation that is included with it. I went thru the beta...

This is how I do it with Money values to word. WIth a few changes you should have exactly what you need.

http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=259&CategoryNm=T-SQL%20Aids&CategoryID=19

-----------------Code-------------------

--You will need this table.--

CREATE TABLE NumNameTbl (

[val] [int]...