Server Configuration

datetime to datetime offset
We are in the process of upgrading our systems entirely. Making huge changes to the hardware and software. One change is going from SQL Server 2000 to 2008. 2008 has the new datetimeoffset data type, which for us could be a God-send. In reading online however, it seems that the date time is always passed in ... 31 May 2010 15:18

bat script in dts
Dear experts, I just migrate sql server 2000 dts to sql server 2008 Legacy DTS I can run MANUALLY those dts smoothly in sql server 2008 Legacy. But when i try to run the same dts in SQL Server 2008 Agent's Scheduled Job...it prompts failure " Process Exit Code 1" for one of my bat script in dts: copy... 31 May 2010 14:11

synchronize sql 2008 r2
Hi I have three Servers with Windows Server 2008 r2 web edition, where I placed an sql 2008 r2 web edition on each. The devices are in the same Workgroup. Generally there is only one machine online. What is the best way to synchronize all data on the second or the third sql server, after booting one of these... 31 May 2010 05:27

Include list
Can somebody help enlighten me on the negatives of a large include list of an index? -- Message posted via http://www.sqlmonster.com ... 31 May 2010 11:58

remote backup in local drive
hi i want to make a backup/copy of a remote SQL Server database and save it to my local SQL Server, any one help me?? or khow a tools that do this??????? -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/201005/1 ... 29 May 2010 07:04

remote backup in local drive
hi i want to make a backup/copy of a remote SQL Server database and save it to my local SQL Server, any one help me?? or khow a tools that do this??????? -- Message posted via http://www.sqlmonster.com ... 30 May 2010 04:42

Database Suspect
To resolve the above problem, the user can use an inbuilt tool named sp_resetstatus. This tool enables the user to change the SQL database status and access the SQL database again. But in this case, this inbuilt tool will not be able to resolve the issue. This tool will only allow the you to connect to the SQL Server i... 29 May 2010 02:49

SQL Server 2005 Agent Will Not Start
I have a database server that has three SQL Server 2005 database instances which one I am unable to start the SQL Server 2005 agent. I received the error listed below when I tried to start the agent. Error 1053: The service did not respond to the start or control request in a timely fashion. Please help ... 29 May 2010 07:04

SQL2008 and Access 2007 Data Project
I am have SQL 2008 and Microsoft office 2007. I created a adp DB that connects to a DB in SQL 2008. Everything seems fine but I can't edit the records in the Microsoft adp database. I have full rights to the db so that is not the issue and. In fact I go into SQL and edit the records without any issues. Ano... 28 May 2010 08:15

Change log shipping to mirroring w/o db backup?
Hi, I've been looking for the easiest/quickest way to change some huge databases from log shipping to mirroring. (SQL Server 2005 & 2008) I really need to avoid the database backup for the initial mirror setup, if possible, since some of these databases are so large. Can it be done or is the db backup ab... 27 May 2010 18:11