Server Configuration

error "the file mydb.mdf cant' be overwritten ..."
Hi, i made a database 'mydb' in sql server 2005 express and a backup of it 'mydb.bak'. I changed some tables, indexes etc ... in the database and made a new backup of this new version of 'mydb' but before that, i changed the previous backup 'mydb.bak' into 'maydboldversion.bak'. So i have now two backup's: '... 8 Jul 2008 07:58

Maintenance Plan
Hi, I setup an Integrity and Optimization job to be ran once a week on one of my SQL 2005 Servers. The job failed over the weekend. This is the output that I get: NEW COMPONENT OUTPUT Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.3054 Report was generated on "inf-sql1". Maintenance Plan: All... 8 Jul 2008 01:51

HELP!!!! The Reports always ask me to enter the password!
Hi, I am using SCOM and I've carelessly delete the encrpytion content in Report Configuration. I've reconfigured the Data Source in the Report Server. I've set connect using "Credentials are not required". However, whenever I run a report, it still ask me to enter the login ID and password! Can anyone he... 7 Jul 2008 06:21

Finding even and odd numbers
Hi! I want to search for even and odd numbers using a SELECT query. I thougth there was a MOD function, but cannot find information or examples with it. I got a SQL Server 2000. Thanks all, -- Marius ... 7 Jul 2008 06:21

Enabling AWE SQL Server 2005 64-bit - multiple instances
In terms of best practice, the first question may be, "do you really need to have 16 named instances on that machine?" It's generally not a good idea to have that many instances unless you have a specific reason for that. Linchi "Vivien Xing" wrote: I am very interested in this discussion. I would like ... 6 Jul 2008 23:13

Installing SSRS over another server within the same domain
Hi all; how much it�s possible to install the SQL-Server 2005 DB engine over one server and the SQL-Server 2005 reporting services (with the analytical services) over another server within the same domain/LAN. Thanks in advanced ... 5 Jul 2008 23:45

creating a new database
Hi, I've installed a Visual Studio 2008CD and found out that the SQL is installed as well,now i need to create a new datbase using SQL ,I go to propgrams>SQL Server 2005>Configuration tools then i have three icons : * SQL Server Configuration Manager. * SQL Server Error and Reporting usage. * SQL Server Surf... 6 Jul 2008 11:57

Running Windows Application over VPN
"JIM.H." <JIMH(a)discussions.microsoft.com> wrote in message news:6158AED7-9BC4-4F04-9245-07668C4244F2(a)microsoft.com... Running Windows Application over VPN I have a windows application that uses SQL Server as backend.I need to install this application to another network and make our users access it. I ... 7 Jul 2008 03:17

Q: Running Windows Application over VPN
Running Windows Application over VPN I have a windows application that uses SQL Server as backend.I need to install this application to another network and make our users access it. I have two options: 1. Do remote desktop to remote network over VPN and run application. 2. Install application into our network an... 5 Jul 2008 08:26

Enabling AWE SQL Server 2005 64-bit
Hi Christian, can you please point to me the link regarding this? "... a fairly recent Microsoft best practice but guidance has just changed over the last few days. The best practice now is only to enable it to if you see the "paged out" error message in the log." Thank you, Vivien Xing ... 4 Jul 2008 23:18