Viewing 7 posts - 1 through 7 (of 7 total)
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...
January 12, 2016 at 2:18 pm
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...
January 15, 2007 at 3:07 pm
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...
January 15, 2007 at 2:55 pm
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...
November 29, 2006 at 1:59 pm
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...
November 23, 2006 at 3:30 pm
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...
April 20, 2005 at 2:47 am
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...
April 11, 2004 at 1:04 am
Viewing 7 posts - 1 through 7 (of 7 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy