SQL Server 2005

Setting up dbmail in SQL Server 2005 on Server 2003

I am having trouble setting up dbmail in SQL Server 2005 running on Server 2003. I am trying to send mail through an Exchange 2007 Server. Do I need to use the SQL Service account with Windows authentication? Also on the Exchange side, how should the "receive connector" be set? Software/Hardware...

TFS VSTS2010

Hello Members,                        I am very new to this blog.I want to need some information regarding VSTS2010 TFS(Team Foundation Server).I have couple of questions in my mind. I really want to share with you. At present time we want to implemnet automation testing...

SQL Server 2005 on Windows 2008 64 bit SP2. Installation issue

I have tried to install SQL Server 2005 on Windows 2008 64 bit SP2. I have installed SQL server 2005 and SQL server 2005 SP2, however only the SQL Server 2005 configuration tools appear. (Everything was selected to install) I have found these posts which have the same issue, but they are...

How to export/ import userschema in SQL server 2005?

To export userschema in oracle, we can use expdp and impdp commands. Do we have any commands to export/ import userschema in SQL server 2005? Also, How to export all the tables to filesystem? Using SQL management server studio there is an option to export 1 table at a time to a file.      

Security Update for SQL Server 2005 Service Pack 3 (KB970892)

hi! each time i try to update the captioned update it fails. i guess it has also caused my ooutlook to crash!!! pls help Software/Hardware used: vista ultimate + off. ent. 2007 with biz contact mgr.

SQL 2005 will not recognize other local disks

SQL Server Management Studio only recognizes one drive on the server, how do I get it to recognize the other Local disks?  The one disk it does see is also on the AX-100, but it will not list any of the others, even the interanl disk, as options for devices to create databases on or for backup...

How to export excel data to Sql server 2005

How to export excel data to Sql server 2005 Software/Hardware used: Sql server2005 and Ms excel 2007

What is the difference between RAM and Cache Memory in SQL Server 2005?

What is the difference between RAM and Cache Memory? Software/Hardware used: sql server 2005

Database restore

I'm struggling with when is the right time to do my last transactional log backup before my full database backup. My question is this: if I do a full db backup once a day at 10pm; and a tran log backup every 4 hours (12pm, 4am, 8am, 12am, 4pm, 8pm). If i have to restore the db to a point in...

Auditing Windows 2003 and MS SQL 2005

Are there any audit scripts I can use to audit Windows 2003 and MS SQL 2005?

Is having the auto create statistics on in a database a good thing?

Hello I have a 250GB database and the auto create statistics is on is that a good thing? Software/Hardware used: sql server 2005

SQL Server 2005 distribution agent failed

Getting this error message [code]Only members of the sysadmin or db_owner roles can perform this operation. [/code] Software/Hardware used: SQL Server 2005

Restore a View Sql Server 2005

I over-wrote a VIEW by mistake. How do I recover the original version of the view? Is there a way to ROLLBACK a "CREATE VIEW..." command? Software/Hardware used: SQL Server 2005

Different database & server collation

Hi, We have a database that is sitting on a SQL Server 2005 with different collation setting, the application connect to the database is running with out any issue. Have anyone had this same issue, if so how long has your application run with different database and server collation without...

Resource usage of SQL Server 2005 Generate Script

Hi, I am wondering how resource hungry the Generate Script for SQL Server 2005 is. We are planing to script out one of our production database on a production server that has over 1000 object to script, and wether this will have more affect on SQL performance during the scripting? Thanks.

Trying to setup a Merge publication between two database Need Help!

HI I am trying to setup a Merge publication between two database and I am having troubles.  I have to server one is HKDD01 and LDDD01 and the HKDD01 is set as the distribution and the LDDD01 is set as the subscriptions. I am trying to create a Merge publication with pull subscription and I am...

Change SQL Server licensing

Hi, I was wondering if it is possible for a 50 seat (i.e. maximum of 50 connection) SQL Server 2000 or 2005 license to be change to a 10 seat? If it is possible is there any limitation on the number of seat that can be change? Thanks

Oracle LIKE statement on SQL Server 2005

I'm trying to execute the LIKE statement but it's not displaying  any values SELECT R_NAME FROM LAWSON.DEPTCODE WHERE (R_NAME LIKE :r_name) Software/Hardware used: oracle 10g

Working TRIGGER and TRANSACTIONS QUESTION

Hello all, My company purchased an operations software (called [strong]darwin[/strong]) that works with SQL 2005 Server. I need to extract some data and save it in my Own Database, which is located in the same SQL Server. On the darwin software there is a screen that updates a field X in a...

SQL Server 2005 is running slow

SQL server 2005 is running very very slow while it hase 32 GB ram 200 GB SAN and 4 Processor of xneon 566 Ghz. The normal select query takes 30-35 seconds to returing 37 records. Please give me the suggestion how to increase the performance Software/Hardware used: OS-window server 2003 R-2,...