the SSMS has an option to script data as wll as the table definitions; i've used it before

but it's weird when i went to Tools>>Options ...SQL Server Object Explorer>>Scripting i...

don't deploy a script ;give the end user a complete backup with all tables and default data already in place; it's faster, easier and not prone to script errors

it's...

I had to lookup Sneakernet on Wiki , already anticipating installing something ultra fast on my network;

That one made my day.

it is much easier to write a file within your application than it is to do it on the SQL Server.

You run into a lot of permissions issues where the...

what is the name of the identity column in the table [stocktb]?

are you trying to force stocktb.[identitycolumn?] to be exactly the same as the productid from the other table, or...

ok, with a lot of rows in the source table,isn't the CURRENT_TIMESTAMP variable still being evaluated on a per-row basis?

can you try this instead?

declare @Last7Days int

SELECT...

really need a bit more of the table definition to give you some solid code examples.

basically, what you want is to use a tally table to help generate all possible...

I'm guessing there's not an index on the[table-name-removed] column yet;

that should speed things up considerably i bet.

use the DMV's to determine the slowest query currently in the cache. examine the queries to see if they can benefit to from being rewritten to be more SARG-able, or...

mail functions are based on the service broker functionality, which is not included in the express versions of 2005/2008; you'll want to buy a developer version for under $50 dollars...

could it be a relaying/mail forwarding problem? are you supplying a username and password for the AUTH command for your mail server?

is the first destination email going to an...

i believe you want to change the default database for that login to master or some other database, now that the original default database for that login is removed.

the name field doesn't have the name like you think: it usually has a ton of underscores plus a unique numbr

try this instead:

select name, object_name(object_id) As ObjName,*

from tempdb.sys.objects

where...

this is just a guess, but AES encryption would match that format, since it can be stored in a varchar instead of varbinary field...but how does that help at all?...

ok... DML triggers for INSERT/UPDATE DELETE have to be on each individual table, i believe; DDL events can be captured on a per-database or per server. so I believe the...