Server Configuration

Compatibility issue???
Is SQL 2005 SP3 32 bit compatible with Windows 2008 R2? Fails every time i try the install. Thanks ... 8 Jul 2010 18:07

How to move all dbo schema objects to another schema?
Does anyone know of a way to move all objects in a db from schema dbo to another schema? ... 8 Jul 2010 06:58

How to tie table to schema?
I use the ssms gui for table creation most of the time; ie, I right click the tables entry, select "new table", and add the columns in design view. When I save the table, the simple dialog asks for the table name; it offers nothing re schema, and the table is linked to the dbo schema. I can easily script the ne... 8 Jul 2010 17:00

Event ID 7031
Dear ALL, we are just experiencing a sort of nightmare since we start migrating database (SQL Server 2000 Ent. SP4 on a Win 2000 AS SP4) from a Compaq Proliant 5500 2 nodes Cluster to a Virtual Machine (VMware ESX 4.0) maintaining Win2000 SP4 and SQL Server 2000 Ent SP4 Before migrating machines, every p... 8 Jul 2010 18:07

ODBC microsoft text driver(*.txt; *.csv) for vista 64
I have two computers. One with Vista 32 bits and one with vista 64 bits. I have build a VB.Net application on the 32 bits computer. The application imports cvs files on a SQL server 2008 express edition that is install on the 32 bits computer. To imports the csv files, i used Microsoft Text Driver(*.txt; *.cvs)... 7 Jul 2010 04:43

SSRS2008 connecting to Oracle
Hello, [SQL2008] & [Oracle 10g] Iam trying to connect to an Oracle database from SQL2008 Reporting Services but Iam facing an error. This is what I have done: - Installed Oracle Client 10g software in the same machine as SSRS2008 - Configured and successfully tested Oracle service name. This is the snippe... 6 Jul 2010 12:17

select max time in AM
I have this simple table: ID------DATE------- 1----2004-08-02 12:30:AM---- 2----2004-08-03 4:30:AM---- 3----2004-10-17 9:30:AM---- 4----2004-08-02 1:30:PM---- 5----2003-02-12 4:30:PM---- 6----2004-02-03 12:30:PM---- 7----2004-01-20 12:45:AM--- 8----2004-07-04 8:30:PM---- I want max time of AM shift... ... 8 Jul 2010 01:34

MICROSOFT SQL-DMO ERROR 5172
Dear All I am trying to attach the database so when i press attach ive got this error MICROSOFT SQL-DMO (odbc sql state 42000) ERROR 5172 :the header file for e\salary_log.ldf is not a valid databse file header the page audit property is incorrect please any idea??? best regards -- Message posted via SQL... 6 Jul 2010 05:44

resource allocation for different query
Dear Experts, Could SQL server allocate resource evenly for each incoming query? Because sometimes when one user perform a long running query (eg. over one hour) , it seems other query were suspended and make its related application timeout/waiting.... Can SQL Server 2008 tune on this ? Thanks. ... 6 Jul 2010 05:44

Date and time in a backup file name
Hi, I have the small T-SQL script below to backup my databases: Here is a snippet: BACKUP DATABASE [model] TO DISK = N'G:\SAVE\SQLSRV\MSSQL10.MSSQLSERVER\MSSQL\Backup\model\model_backup_2010_07_05_212931.bak' WITH NOFORMAT, NOINIT, NAME = N'model_backup_2010_07_05_212931', SKIP, REWIND, NOUNLOAD, STATS ... 6 Jul 2010 16:42