here's a solution that creates the statements in FK hierarchy order by using one of the sp_ms procs;

note that I know it is not 100% perfect; if the database has...

i know the default UDP port is 1434, but could not find it anywhere in my registry;

i've pasted a script below that finds the TCPIP ports being used, but i...

the public role is sufficient to give the user access to create the DDL for any table/view/proc;

I just created a new user and gave them the public role to a...

an interesting idea; i've got databases that have a lat/longitude for each county, so you could calculate where nearby counties are < 40 miles or something; but that's not what...

to get the fk constraints related to a specific table, use the proc sp_fkeys:

use pubs

sp_fkeys titles

results:

well my dev machine is just that...development, sample data, and if i take the service down to defrag, there's no real impact. , so i have a scheduled task of...

sounds like the application needs to be tweaked so that the name/connections to the server are parameterized and placed in an ini file, instead of hardcoded. an app should NOT...

you have to open a port in your firewall to allow your sql server to be visible to an outside IP address; further, if you are going to do this,...

if the file is in use, contig will skip the file, so yuo'd have to stop the server to defrag the mdf/ldf files;

i have it scheduled on my dev machine...

granting someone the role ddl_admin allows them to create procedures i believe, and by default anything they create they can execute.

here's my suggestions, but by no means do i purport to be the ultimate guru of query tuning;

#Source D and #Calculator_Table C are temp tables,make sure you put indexes...

to expand on what SQLZ said, with an ugly example:

do this on test copies until you are sure:

--identify the missing records, change the tablenames and dbnames to what is appropriate

installing SQL Server on a non-Server operating system automatically dummies itself down to MSDE; no need to download a dedicated executable. are you getting the dialog where you can install...

SQL Server Express/MSDE has a limit to the number of concurrent queries,

it's designed so a developer can test with the same codebase, but not with the same workload as...

i would have thought that differences in collation are what is breaking your comparisons.....but if all the columns are the same collation as the database, i would think that that...