Or try this one:

http://vyaskn.tripod.com/handling_email_addresses_in_sql_server.htm

INSERT INTO myTable

Exec sp_spaceused

Try this:

Exec sp_MSForeachDB @command1 = 'Use ?;SELECT DB_NAME(),FileName,

CASE

WHEN Growth = 0 THEN ''NO''

ELSE ''YES''

END as AutoGrow

FROM sysfiles'

Hmm, I must admit...

Brandi,

I would check if the MSSQLServerOLAPService is installed on the machine. You could also check if a folder ...\Microsoft Analysis Service exists but the service is a better option.

When it...

Just google on "sql duplicate records rows" and you will probably find hundreds of these scripts.

I'm sure that if you search in the scripts section of this site you will find at least 4 or 5 scripts dealing with spaceused etc..

Here's one which deals more...

Swati,

the only explanation I can think of is a collation issue. Maybe the database (or table or column) collation you use in SQL server is different from the Orace collation.

You wrote that you have AWE enabled but only use 600 MB of RAM. AWE memory is over 4GB so you better disable that again.

Now to the timeout problem, I've...

First of all why would you want a primary key with a length or 32. Seems extremely unefficient to me.

Second could you post ure DDL. Now I can only gues...

If your database still has the status loading, you probably didn't select the recovery option when restoring the backup. Start antother restore and make sure you've select RECOVERY option.

The message...

Don't double post. See the answer here:

http://www.sqlservercentral.com/Forums/Topic426742-146-1.aspx#bm426745

With sp_trace_create you an create your own trace. The easiest way is prpobably to define a trace in profiler and then script the trace definition.

About writing the results to a...

I agree with Kenneth that your procedure looks for systransschema in the local datbase.

I ran into similar issues then writing such a procedure, but instead of prefixing all the...

Thayal Muhunthan (11/27/2007)

---

How do I add a 3GB swithch .. I have installed 2.5 and the Total memeory showing as 1.6 GB, not even 2.0 GB ..

Could please let...