That is not correct! I have a named instance in my development computer an it gives me : COMPUTERNAME\INSTANCENAME

 

When you write something to be posted on an internet site that could potentially reach a lot of people the content as well as the way in which you convey your...

this is definitely a Detach! Drop would have "erased" the files

 

From the instance perspective there is Only ONE Db so I don't think it can cause a problem!!!

 

Simply put:

Use a permanent table and add a column with s_user_name as default. Then all queries should be filtered by s_user_sname (with a view perhaps 

sp_prepexec is a utility implemented by the ODBC driver and should not be used directly. If you need to perform such a task you need to use ODBC on your...

Right again!

Not hard to write, Very simple to maintain and your final product should look neat with static fields only

That is the Right approach!!

Many people try to justify dynamic sql with the Idea that the columns and tables are very volatile in their environment. That is plain wrong. If...

 

You are better off using the FoxPro ODBC Driver or the FoxPro OLEDB Provider:

ODBC Driver: 

SELECT s.*

FROM OPENROWSET('MSDASQL', 'DRIVER={Microsoft Visual FoxPro Driver};

Exclusive=No;Collate=Machine;Deleted=Yes;Null=No;

SourceDB=e:\data\Model.dbc;SourceType=DBC;',

'SELECT * FROM YourTable')s

OLE DB provider:

SELECT s.*

FROM OPENROWSET('VFPOLEDB.1',

'e:\data\Model.dbc';;,

'SELECT...

To get access with dynamic sql you need to copy the data into a temp table.

This is how you do it in SS 2k:

 http://www.sqlservercentral.com/columnists/lPeysakhovich/anaudittrailgenerator.asp

 

Now, I have never agreed with...

Very wise on your part. Just always remember this:

When you read the fine print you'll adquire knowledge, when you don't you will adquire experience