Yes they will both work.. it's just a matter of preferrence, I preffer to avoid errors when I can. Especially in vb6 where err handling is a big pain in...

You'll have to do load testing. If you expect to have let's say 5000 rows in your table, then I'd test for 15 000 and even 50 000 just...

You could run something like this...

IF EXISTS (Select * from dbo.SysObjects where Name = '#your table name#' and XType = 'U')

SELECT 1

ELSE

SELECT 0

This would return one if the table exists....

CREATE TABLE [Numbers] (

[PkNumber] [int] IDENTITY (1, 1) NOT NULL ,

CONSTRAINT [Pk_Number] PRIMARY KEY CLUSTERED

(

[PkNumber]

) ON [PRIMARY]

) ON [PRIMARY]

GO

Declare @i as int

set @i = 0

--I use...

What do you mean by online an ok?? what problems are you expecting from this table (database).

You can't join on a table function that accept dynamic parameters. Imagine how hard it would be to do that?? Let's say you have 100 rows in the main...

Please read THIS before continuing down this path. Dynamic sql should be avoided at all costs.. Especially with an asp project.

I'm not talking about switching from SQL server to MS.

I'm saying that you can use MS access to connect to sql server and use MS access as the EM of...

I have many solutions in mind but I need to know extacly what you are trying to accomplish. Can you provide us with the DDL of the views and...

Is MS access installed on the server??

If so you can create and Access Data Project.

Open access, in the file menu hit Create a new database, then under the general tab...

Yes it will be a nightware. You'll have to add a column Ranking in your Table, populate it using the methods shown in the links, and then on every...

That's why i can test it.. have no linked server and no other server to link to.

The only difference I see between the working script and the other is the quotation marks :

"tkdmun02\test01"

FROM '+ @servername+ '.master.dbo.sysdatabases

maybe if you tried this :

FROM "'+ @servername+ '".master.dbo.sysdatabases

But...

Have you tried doubling it "tkdmun02\\test01"?

Here's a short query :

Select dbid, name from master.dbo.SysDatabases