Folks, does anyone know how to find out which isolation mode was used for
statement execution?
Gene.

Hi there peeps,
we have a customer who is running SQL 2000 with a goldmine database in it.
It is running on an SBS 2000 server and we will be performing an SBS swing
to 2003. What do we need to do to move the database?

I have a strange problem with a table in a SQL Server database we have. When
I query one of the columns in the table with a "IS NULL" where clause I get
no rows returned. It does not matter if I set ansi_nulls on or off the result
is the same. However if I use the query "select ...

Dear Friends,
I would like to create a stored procedure that loops thru table a and
inserts values in table b.
table a has the following parent child relations.

Is there something like sql2005 ddl triggers taht I could create in sql2000.
Basically, I need to have trigger on database level to trace for anyone who
change sql objects(table schema change, SP mpdification...)
Thanks,

I am running SQL 2005 Express locally with the intent to learn the basics of
SQL Server before our business makes a purchase (Looking to move away from
Access)...
I am running Windows XP SP2 as a non-admin. As the local administrator I

Ok, if anyone can help it would be appreciated.
im mulling over whether to use MySQL or SQL server for database
development on web applications. Basically i had always used access
but now that we have decided to take on bigger projects i feel i need

If I have a table called tblEmployee with columns of diffeernt types, I can
do something like this
SELECT * INTO #foo FROM tblEmployee;
and it will create #foo with all the correct column types and insert the

I know that this question if quite silly. However, here is what happens: i
run dta from time to time and get recommendations to create indexes on table.
This table has already 6 indexes and all of them are used today(user_seeks
and last_user_seek columns from dmw show that). So ...

Any ideas on how I can safely set every job owner to sa in SQL Agent
with a script?

This syntax works correctly with Access 2003 to dump a table to a flat
file.
SELECT *  into  [text;database=c:\].[tstjuly9#txt]
FROM tblInvoices

I have SQL2005 installed on Windows 2003 standard R2. We are thinking about
in-place upgrading the server from standard to Enterprise. If we do so, will
SQL data preserved or such in-place upgrade is not suggested? Thanks for the
advise.

I'm having some problems converting a string to a datetime.
For some reason some dates in my db are stored in varchar-fields. I
have to convert these to datetimes, because I have to make
calculations with them.

backup log db with truncate_only
DBCC SHRINKFILE (db_log, 100) WITH NO_INFOMSGS
backup database db to disk = 'd:\backup\db.bak' with init
does the 'backup log' statement flush all transactions to the db

Hi, I need to monitor sql db table schema change.
is there any system tables taht I could use to see any schema changes?
Thanks,