I've been trying to kind of reverse engineer SISS bulk loading
functionality without making a dtsx file. Watching the execution in
profiler when it gets to the actual bulk insert point in the job the
command comes up encrypted. I'm assuming it's bcp but I'm not finding

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.