Nice question, bad answer.

"SELECT * FROM information_schema.ROUTINES" also returnes functions, if I want a list of stored procedures it should only hold stored procedures.

The most important part of SQL is...

Hi Bertus

I found this answer somewhere else:

It means that you have not physically added these fields to the customers table and orders table. VP-ASP simply updates and displays these...

Hi Thomas

Why do you want to move two tables from database A to database B if you need to reference them with stored procedure from database A.

If the data is part of...

When you create a publication, you start out by creating a snapshot.

The default place to put this is on a share where you have to be an administrator to get...

If all the servers are in the same domain and your domain account are sql server system admin you would do something like this:

Make a bat file where the first...

The master.dbo.sysservers holds the name of all SQL servers known to the local SQL Servers, including its own name. This srvname has srvid=0.

If you run the command:

select @@SERVERNAME

the result should...

I have just tryed to create a database throu Query Analyser, with autoclose turned on at the model database, this did not create the problem.

Then i tryed to create a database...