DB Engine - SQL Server

Thread preview

Thread	Last Post	Replies

Expanding database ??	17 Mar 2008 12:36 GMT	1
After I reboot my server server 2003 with SQL it expands the room taken on the RAID array and then drops back after leaving only 10GB on 150GB hard drive space to ony 40GB leaving 110GB. Any ideas to why it does this after a reboot.
Poor performance when using Transact SQL cursor	17 Mar 2008 11:35 GMT	5
After a recent upgrade from SQL Server 2000 to SQL Server 2005, we get problems with certain queries using a Transact SQL cursor. I have noticed the following: Table with a smaller number of rows.
How to determine which file belongs to which filegroup and which database	17 Mar 2008 07:12 GMT	6
I am writing a C++ program that will take backup of .mdf files. I will be provided with .mdf files. And for that mdf file, I need to know the database name and file group name associated with this .mdf file. How can I do it? Please help me to sort this out.
SQL 2005 Rebuild Index	17 Mar 2008 01:22 GMT	5
My department is experiencing difficulty with SQL Server 2005's Rebuild Index functionality. We are upgrading from 2000 to 2005 in the near future and I was tasked with creating a maintenance plan consisting of: Integrity Checks
Private Profile for Database Mail	17 Mar 2008 01:06 GMT	3
I am trying to create a Private Profile for Database Mail, however there are no accounts available for me to select. I can and have successfully sent mail from a public profile containing 2 different accounts, so I know I have it working. How can I create a private profile? Also, ...
Non default port	17 Mar 2008 00:32 GMT	7
I am using SQL 2005 and have multiple instances installed on multiple servers. None are on the default port. When I connect to box 01 without specifying the port in the connection string, it connects. But on box 02, it will only connect to the instance if I specify the
memory allocation error	16 Mar 2008 17:04 GMT	3
using sp_configure we inadvertanly set the network packet size too big, an didn't get a warning. when we restarted the mssql service we found that the sqlserv instance wouldn't come up.. we were able to go into the tools >> options >>
How to detect SQLServer 2005	16 Mar 2008 08:25 GMT	1
How can I detect if my computer have installed SQLServer 2005 or SQLServer 2005 Express with program like c# or VB.NNET?
How to copy views between servers?	16 Mar 2008 08:15 GMT	4
I want to copy some views (not data) from one server to another. How can I do that?
Transaction Log and Raid	16 Mar 2008 06:34 GMT	4
I am looking to improve performance of the sql system. I have the trans log split onto its own RAID5 drive. We are thinking about going to RAID0 to try abd boost throughput. Any ideas? Richard
Recovering SA Password or Adding sysadmin Login	15 Mar 2008 23:05 GMT	1
Recently some body played with our SQL Server and removed our Sys admin group login and we dont have builtin\admin as login and no SA Password can any body tell the way to come out with this situation to change the SA Password or create our Group back with Sys admin priviledges.
CPU usage	15 Mar 2008 18:31 GMT	6
I have been using SQL Server 2000 for some time and am attempting to upgrade to SQL Server 2005 (testing the trial version). I backed up my SQL Server 2000 database(s) and then restored them on SQL Server 2005 which worked well.
SSIS/DTS with SQL Server 2000?	15 Mar 2008 08:59 GMT	1
I am working with a SQL Server 2005 client while the server still runs SQL Server 2000. SQL Server 2000 had DTS while 2005 has SSIS. Given that the server still runs 2000, is it possible to write a DTS package in 2005 that
Debug DTS	15 Mar 2008 08:50 GMT	1
I have a DTS package. I need to debug it, ANy ideas how? Thanks,
Unistall a SQL Server 2000 Hotfix	15 Mar 2008 08:43 GMT	1
I'm preparing to install SQL Server Hotfix 2187. I have 4 standalone servers all running SQL Server 2000 Enterprise Edition SP4. I've been trying to figure out how to uninstall the hotfix in case something goes wrong. I can't find any information on the Microsoft website, or ...