If it's not your own server, for example if it is going to be hosted at GoDaddy or some other host, THEY will give you the user name and password...

you don't need a trigger for this...you could handle it automatically by making status a calculated field instead of a bit you have to update:

[font="Courier New"]CREATE TABLE TEST(

    SID INT IDENTITY...

i've got a stored proc i made that i named sp_getDDL, which trolls thru the table definition and it's columns and builds the script for the table; it's probably...

just change to a temp table, no problem:

CREATE TABLE #LinkedServers (

...

my new avatar makes me feel more intellegent...err...inteligent...err..intelligent!

yep you can fix this:

Tools>>Options>Text Editor>>File Extension

type PRC, choose Query Editor and hit Add; next time you load that file extension, it will use the syntax highlighting engine:

if you need to fix the LineItem table prior to archiving it, you might want to do something like

UPDATE LineItem SET LineItemID = LineItemID + 240000000

that, by...

this is just a prototype for a single database, but it's easily adaptable i think.

I'm assuming that the current server has all the linked servers....so I thought why not search...

specific procedure is slow...but runs fast if you run the statement in SSMS?

sounds like parameter sniffing to me.

when the code is compiled into a procedure, the compiler makes a best...

fragmented MDF files happen in situations where the file gets shrunk, or needs to autogrows to hold more data.

ideally, you pick an initial size of a database so that the...

this updated code that i posted previously does not raise any errors. it cannot get teh definition on drop procedure, but it does get creation and changes.

[font="Courier New"]

CREATE TABLE [dbo].[DDLEventLog](

        [EventDate]...

I looked in the registry on my machine, and I think this is where you want to go to delete old servers you no longer connect to:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SuperSocketNetLib\LastConnect

mine has a list...

the problem is, some domain users may come in with more rights than you want to give them....a domain user might also be a domain admin, so giving a group...

because this question looks a lot like what a homework assignment would require so that you get used to querying and displaying data, you'll need to show us what you...

look at the sysobjects table.

there is a column there called "xtype". you could count(*) from sysobjects where xtype='U' for example, to get all user tables. V for views, you can...