Have you compared the write cache options on both servers?

Use Device Manger, Disk Drives, select a disk, right click ==> properties and then select the "Disk Properties" tab. Is...

Do you have SQL Server Service Pack 4 for the Client tools installed ?

A few means of diagnosing the problem:

a) Use SQL Profiler to capture event "Login Failed" (under "Security Audits") and columns loginame and hostname.

Then try to connect and Profiler...

From Books On line, for three data types, the storage bytes and maximum value are listed below. Also provided are the number of years before the maximum value is...

Please provide DDL and sample data and do not provide narrative and listings. http://www.aspfaq.com/etiquette.asp?id=5006

The real problem is that the table are not normalized. In this case, the "CourceGroup"...

set @SqlString = N'select @Column_name = Column_Name from information_schema.columns where table_name = ''' + @Table_Name + ''' and Ordinal_position = ' + @Counter

This set statement is intended to append...

As a rule of thumb, when joining, the on criteria will be the primary key of one table equal to the foreign key of the other table.

If you are not...

I can reproduce your problem by setting the some environmental options by running either:

set dateformat dmy

set language British

You seem to be expecting this option to be mdy.

Run DBCC USEROPTIONS to...

" i want to deliver mdf file in the cd and my software will attach it , but i want to limit that no one can attach it in...

Please do not post in more than one forum.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=346521

Your requirement statement is too vague to define a soulution

Please provide DDL and sample data including the "model office" table, the condition table and the "model office condition" table. ...

"Has anyone had trouble using and backing up 300GB + databases in one file? "

With a SAN, not using large database specifically.

For backups of larger databases, recommend performing parallel backups...

To diagnose, run SQL profilier and monitor events for logins including failures, sql:batchcompleted and sql:batchstarting

This will capture the exact SQL being issued by the application and any error messages.

"I also tried using sp_MSforeachdb to no avail"

You need to be aware of the parameter @replacechar, which defaults to '?'. Try this SQL:

if object_id('tempdb..#Objects') is not null drop table...

Here is some SQL that you can run:

-- For logins

Setnocount on

Selectcast( serverproperty ('machinename') as nvarchar(128) )as machinename

,coalesce ( cast( serverproperty ('instancename')as nvarchar(128) ) , 'default')as instancename

,loginname

,createdate

,updatedate

,dbname

,language

,denylogin

,hasaccess

,isntname

,isntgroup

,isntuser

, password

From master.dbo.syslogins

go

-- Server...