does anybody know in-memory features in sqlserver? i want to put some
realtimr tables into memory storage.
thanks,
John

I did a test run on creating some tables in a database.  I  didn't
name the database so they went in "master".  Now I fixed the query and
added some key fields etc.  I want to drop all the tables and re-run
the query.  I tried

In SQL Management Studio...
If I right click on "Stored Procedure" there is a option to select "New
Stored Procedure"
However....

Has anyone ever seen a problem with creating SQL Server 2000 Stored
Procs using the encryption option?
Details
-------

I want to start over because I fixed some keys and fields.  The first
create database was a test.  So I wonder how to drop the database.  I
have the drop database template.
My database tables were created in "master"  which I assume is a

When I run DBCC SHOWCONTIG, the Logical Scan Fragmentation row is missing
and it only displays the following:
DBCC SHOWCONTIG scanning 'TableA' table...
Table: 'TableA'  (1407344078); index ID: 0, database ID: 18

I have done as mentioned by Microsoft in following URL
http://support.microsoft.com/kb/308853
Though, Service "MSSQLServerADHelper" is not getting off from Service
list. Can anyone help me how to remove that name from Service list.

I ran a query to create tables as a test run because it was a
conversion.  Then I dropped all the tables in the master database made
some changes to the query and re-ran it.  Now I cannot see any of the
tables even though it says the query ran successfully.  I really

Not sure if I am posting this in correct group but here is my issue:
I have a table called JSTATUS.
Columns are:
ajid

I have a syntax errors in my T-SQL querie.
The first doesn't like how I designated the foreign key:
--
-- Table structure for table[INTERNAL_CAR]

Not sure if I am posting this in correct group but here is my issue:
I have a table called JSTATUS.
Columns are:
ajid

A very good day to all of you.
Currently, i am working on implementing dataware.
I had done some research on it and all i could find are definations
and how to design a good data warehouse.

The company I work for has 4 Microsoft SQL clusters (running SQL 2000 & SQL
2005) with 3 SQL instances per cluster (so 12 instances total). Historically
we've used the "sa" account for pretty much all access to the databases. We
recognize that this is a bad security practice and ...

There doesn't appear to be a "Format" function in Transact-SQL (like the
Format function in VBA or the Text function in XL), so that I can format my
numbers any way I like (and turn them into strings).  Please correct me if
I'm wrong.

We have a very busy DB (1000 transaction a second) (High amount of writes)
We noticed that every 3 minutes database becomes unresponsive and CPU drops
to 0 (usually it is at 10-20) and then goes to 100% for about 5 seconds
(transaction queue is probably accumulated while database ...