see this thread:

http://www.sqlservercentral.com/Forums/Topic326235-5-1.aspx it's got a complete explanation on the flags., as well as a code snippet to plug in your status and get the results on page two:...

to add to what Henrico gave you, here's a collection of some of the available functions for that kind of information:

i logged in as sa, then my windows domain, and...

basically my recommendation mirrors vaibhav's below; four parameters, two for column names and two for values;

if you are going to do that, however, why not just build the whole ,...

it's just syntax.

After the datatype, you say constraint/nameOfConstraint/Type of constraint if you are doing it inline:

CREATE TABLE OWNERS2 (OwnerID INT CONSTRAINT [PK__OWNERS__TWO] PRIMARY KEY IDENTITY)

defining a constraint name is optional...primary key, foreign key, defaults, check constraints...all of them will be auto named unless you explicitly define it:

here's your table with the named constraint instead:

CREATE...

here's a link to an ms article that goes over ASP vs ASP.NET session state;

http://msdn.microsoft.com/en-us/library/ms972429.aspx

usually the session is heald in memory, so it's a little slower with the roundtrip to...

a new database is really a copy of the model database.

if you add user,sroles, functions,tables,procs or anything else to the model database, all new databases inherit them when they get...

see if this helps you; it produces results like this, where NULLS mean the db was never backed up:

Number of Days since last backup Backup type (D-database,L-log) backup_size...

i think as soon as you try to simplify and abstract stuff, it makes it harder to understand. pseudo code sux sometimes...tablex/database a/b...yuck.

so do you have multiple tables(maybe in other...

on my machine i had 2005 installed a couple of times as various instance names...then i installed 2008. cleaning up some extra unneeded isntance names,

i now have the 2005 db...

i must have tunnel vision this morning;

i didn't see any BULK insert scripts for the files; after downloading the csv files, i see they are UNIX style(slash r for the...

there is a default collation at the database level, which you can see in sys.databases.

collation is not at the table level, but for each individual column. the value is visible...

first, you should never store dates as any datatype except datetime.

fix it now so you don't have the same issue in the future; if it's stored as a date,...

i believe the setting "Generate Scripts For Dependant Objects" is True on one machine, but not the other.

Tools>>Options in SSMS, then you have to find the node "SQL Server Object...

I know that when you look at sys.triggers and the db_id is zero, it's because it is a Logon Audit trigger, so it's not associated to a specific database, but...