There are plenty of ways to do that. You could pass the business name as a parameter in each case, and have IF...ELSE statements. You could have different...

If you're using Windows authentication for your security, then you need to take additional steps for the distributed connection. Windows security can't "chain" to more than one computer. ...

Not sure what you mean by the schema for a file. Do you mean for a table? (It looks like that's what your code is meant to do.)

If...

As far as the query to build, what you're describing is called "dynamic SQL". You'll need to take a look as sp_executesql in Books Online. It will tell...

I often find the percentage useful, at least as a starting point.

My favorite laugh at the usual "database as the foundation" analogy is that you really can't build two houses on the same foundation.

On the other hand, the usual house is...

Take a look at sys.dm_os_wait_stats. See if that will do what you need.

Access has wizards to help you write a stored procedure. They're limited, but they can help you get a start on it.

A form can have a stored proc as...

I don't know of a direct way to accomplish this, but a work-around I've used is make the first step in the package be a "running check".

There's probably a better...

In my tests, the explicit begin/commit won't add any performance overhead, but you should test both and see. I don't think I've ever relied on someone else's performance tests...

garyreeds (5/29/2008)

I need to tune a stored procedure. for that iam seeing the execution plan after the whole procedure is executed. is that correct way or I need to run...

Have you tried defragmenting the table that takes longer to query?

You can't install SQL Standard on Vista Home. It won't let you. You either need a different version of SQL Server, or a different version of Windows.

If you...

If I understand you correctly, what you're seeing is just the memory use of the SQL Server service (120 Meg), vs the total amount taken by the server (3.5 Gig)....

I ran something similar for 6 years. Mine was Access 2003 on SQL 2000/2005. One thing I definitely recommend is look into having the queries be in the...