if there...

that is exactly why you'd want to not store a date as a number: 20091221 you can kind of read as a date, but what if the value is 20091250...

you'll want to use the GUI in SSMS;and change it to bigINT; the GUI will create a new table witht he proper structure, migrate the data, migrate all the foreign...

it depends on what your "number" is going to be;

SQL natively keeps the number of days since 01/01/1900:

select convert(decimal(12,0),getdate()) = 40167

select convert(decimal(12,4),getdate()) = 40166.5383

after the decimal point, it is the...

fill factor depends on the flavor of inserts, so it's not something that can use a rule of thumb/assumption;

for example, if the primary key of a table is date...

thanks for the input guys;

for my first pass of fixes, i used gvim, but it's not the kind of utility i'm used to...i prefer text editors that open multiple files,...

dates can seem tricky until you get used to them.

never convert a date to varchar or anything...always keep them in datetime .

this will give you the Monday of the current...

Pete there is a difference between Joining and using a WHERE statement to limit your results; I'm thinking that you are including the WHERE statement as part of the join,...

As Jeff's link pointed out, you can easily script the enabling and disabling of xp_cmdshell;

if you had checked BOL before posting a question here, you'd have found it yourself, and...

good job posting details Bryan! that gives us just what we need for testing.

with the table definitions, we can emulate what you are doing, and provide solid comprehensive answers.

now we...

details, that's the key.

you said you want to put XML in the following folder:

c:\AllSites\romah.com\ folder of target

does that mean the web server and the sql server are the same...

if you are getting a specific error, we really need to see the code in your triggers; that's where the error lies; it sounds like you have declared variables in...

still fairly easy: you jsut add the dependancies and the columns to teh same query:

SELECT

CASE

WHEN object_name(tr.parent_id) IS NULL Then 'Database'

...

here's an example of what Jason was talking about; my SandBox database had a database trigger, and I thought that deserved mentioning and a demo of special handling:

SELECT

...

the best way is to switch to your own cursor, and do whatever you were going to do to the specific tables;

here's a generic example; note how you could exclude...