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...

our shop thinks of DBA's as two different categories....there's development DBA's, which only need access to the databases in order to create schemas, write procs,review other developers code, etc.. That role...

when you changed your database collation, did you change all the existing columns too?

a temp solution would be like this:

select * from gmact where actnbr like '120%' collate Sql_Latin1_General_CP1253_greek_CI_AS

a permenant...

in order to do that, the account used to run SQL server would need to have network rights...so instead of the default of running as system, it would need to...

i looked in google groups and everyone who responded witht eh same error had instaleld the free copy, and then the production copy, which was technically a different version:

http://groups.google.com/group/microsoft.public.sqlserver.server/browse_frm/thread/cc9c2343aa5bdfee/bf12353373a242e4?lnk=st&q=The+Notification+Services+instance+encountered+an+error+in+one+of+its+components+and+must+stop.&rnum=1&hl=en#bf12353373a242e4

sounds...

post the query; most likely we can help tune it ; most likely the WHERE clause can be tuned to use SARG-able arguments, which will then use the proper indexes...

If you create an empty database, but make the space allocated 10 GIG, you'll need 10 GIG to restore that backup, even though the database might be empty, or much...