Sql-server-2000 Questions

How do i return a constant from an sql statement? for example how would i change the code below so "my message" would return if my

Is there a way to stop the log file from growing (or at least from growing as much) in sql2000/2005? i am running a very extensive process

I know a role name and want to find all users in this role. how do i acheive this in sql server 2000 (in the sql script, not in management studio

I've got 2 databases on one server; let’s call them db a and b. database a is about 11 gb, database b is very small (155mb). database b has

Assuming such a query exists, i would greatly appreciate the help. i'm trying to develop a permissions script that will grant "select" and

I use sql server 2000. suppose i have two tables like the following: area ---------------------------------- id| name |

It seems that some scripts generated by enterprise manager* (or not, it doesn't matter) created check constraints with

I have a series of t-sql statements separated by the special query analyzer batch separator keyword: go if one

How to sum data week wise in ms-sql 2000 i have a table "reports" with the following columns. totalsubmissions, zoneid, rptmonth,

Have you ever seen any of there error messages? -- sql server 2000 could not allocate ancillary table for view or