1,847 reputation
1115
bio website
location Rochester, NY
age 53
visits member for 5 years, 6 months
seen Oct 24 at 23:42

Dec
4
comment Scheduled task does not run on WIndows 2003 server on VMWare unattened, runs fine otherwise
What prorgram are you using to do the copy? I would use robocopy and set the logging attribute, and the verbose option.
Dec
1
comment Replicating/Synchronizng multiple tables across different Databases on the same instance
Why not create a view in DB2 that references the tables in DB1?
Nov
29
answered sql server: how to load broken views
Nov
19
answered is there a GOTCHA - DBCC CHECKDB ('DBNAME', NOINDEX)?
Nov
19
awarded  Organizer
Nov
19
revised is there a GOTCHA - DBCC CHECKDB ('DBNAME', NOINDEX)?
edited tags
Oct
30
answered SQL Server 2008 express r2
Oct
30
answered SQL Server moving to new file
Oct
25
comment Does SQL Server 2008 R2 lock memory pages by default?
Those messages confirm lock pages are enabled
Oct
24
answered Does SQL Server 2008 R2 lock memory pages by default?
Oct
20
answered Create Secure External Connection To Sql Server
Oct
19
answered sql2005 maintance plan 4 bak files?
Oct
14
comment Should I put my VCenter Database on a server with other enterprise databases
+1; shared servers always have caveats; one app might require a certain SP, and others don't support it; aligning maintenance windows can be a nightmare; as long as cpu and disk space are under control and watched, it can be done.
Oct
11
comment Shrink SQL Server data file, but not all at once?
Is the db FULL or SIMPLE recovery mode? How's your log space? What's the load like on the database while you're doing the shrink?
Oct
7
answered Performance Monitor w/ SQL Server - how many counters is too many?
Oct
4
answered SQL Server 2008 Management Studio Add-In for missing where clauses
Oct
4
awarded  Civic Duty
Sep
30
comment How can be cout \Process(sqlservr)\% Processor Time over 300 %
and is hyperthreading enabled?
Sep
19
comment Certain SQL queries performing very poorly in ESXI hosted environment
+1 for the summary; probably worth pointing out that removing the BEGIN TRAN/COMMIT essentially adds an implied BEGIN TRAN before each UPDATE, and a COMMIT afterwards, making 1700 commits, and is much more dependent on speed of the disks, physical or virtual.
Sep
9
comment IIS7 application using wrong SQL Server 2008 Express database
re your edit: you say it's trying to use the production database, but the error references the DevMyDbName specifed in the connection string. Are you sure the devuser account you created has access to the dev database? Can you try to use sqlcmd with the new account to access the database?