SQL Server 2005

sqlserver2005 on windows vista home premium(32 bit)

i have sqlserver2005 wid service pack 2 installed,it gives server names as-'user-pcsqlexpress'&'user-pc'. But wen using visualstudio2008,if i give this as the server name during database connectivity it does not recognise and the error msg says that d server doesnt exists.Please give me a solution

Bulk-Logged Recovery Model SQL Server 2005

If I change the recovery model on the database from full to bulk-logged to run DBCC CheckDB and Rebuild Indexes is changing the recovery model the correct thing to do? Software/Hardware used: SQL Server 2005

SQL Server Transaction Logs

If I change the recovery model on the primary database from full to simple and then change the primary database back to full again. Would that break the log chain? It seems the log shipping breaks after we do that. Software/Hardware used: SQL Server 2005

SQL DB Manage/Admin

Any suggestions or ideas on DBA enterprise software for managing remote sqlservers??   Looking for tools to manage and administer from one main sqlserver.   Thanks Software/Hardware used: Windows Server 2008

ACCESS 2007 and SQL Server 2005 Schema Updates

We have several clients with access to reports (provided via Views). The reports for each client are separated by being under a different SQL Server 2005 Schema. Obviously we can get each client to link to their Views but the client wants things to work like an ADP - that is, as reports are added,...

PRINT statement in Stored Proc SQL Server 2005

Does PRINT statement in stored proc cause network traffic or any performance issues? Can i get some tips to write good store proc that gains performance.   Thanks.

T-SQL query to ACESS 2007 database

I need examples of T-SQL queries running on SQL Server 2005 that retrieve data from a MS ACCESS 2007 Table. Any explanations are appreciated. Thanks

Adding data in SQL 2005 server

i am trying to add data on an sql database from backend problem is it does not acceptnull values kindly help. My email address is edmuia@yahoo.com

view active directory data using SQL server 2005

How could I view active directory data using SQL server 2005. For example I have all of the data available in Human Resource system and I would like to pull some of the information to the active directory like name, position and department … ext where the user name is primary key. Thanks alot...

SQL Server 2005 - Unable to Eun a Pull Subscription due to "unable to connect to distributor" error

I have 2 Windows server (Windows Server 2003) running SQL Server 2005. Server 1 is the distirbutor and publisher. For a snap-shot replication, I have no problems running a push subscription from server 1 to server 2. However when I try to set up and run a pull subscription on server 2. It fails...

SQL Server 2005 question self join query

I have one table that name is TblCategory on that 2 columns are CategoryName another column name is UpperCategoryID my table is like this CategoryName UpperCatID ------------ ----------- Book Commerce Commerce Accounting Science Math Commerce B.O....

Memory overhead recommended for benchmarking SQL server 2005 on vSphere

For a 'direct' physical to VM comparison of SQL server 2005, would anyone recommend giving the VM extra (say, 1.5GB) RAM to compensate for any overhead the OS needs? So a direct comparison would then be 1vCPU, 2.5GB RAM VM & SQL set to use 1GB RAM) vs. SQL on physical host set to use 1CPU and 1GB...

SQL Server Profiler's TextData Column Has NULL And Longest Duration value

My Profiler's TextData Column Has NULL value and Longest Duration value (100000ms). What could be the reason? Thanks

Identity Reseed SQL Server 2005

I have the following table create table SubscriptionTrans ( transid bigint identity(9223372036854775805,1), transdate datetime ) Run the below insert script 3 times. insert into SubscriptionTrans select getdate() You'll get below error Msg 8115, Level 16, State 1, Line 1 Arithmetic overflow...

SQL server as data source for OBI EE

hi everyone,i have been using OBI EE for the past 2 months.I have been using Oracle 10g database as a data source for OBI EE and it worked just fine and now im trying to use SQL server 2005 as my data source. My ODBC was succesful and i can import from that database but i get following errors when...

SQL Server 2005 Query Very Slow in the first run

Hi, I have an sql query which takes 8 seconds in the first run. The next run there after takes 0.5 seconds and all consecutive runs take 0.5 seconds. Is the plan getting cached? How do i make this query run in 0.5 second in the first run itself? Please find the query below. select...

SQL server 2005 to SQL server 2008

I am following using sql server 2008 but following some lessons written by BOB Taybor. Is MyCompany.mdf for 2005 abailable in 2008 format?

How to move SQL Server databases to a new drive.

I have installed all my databases (nice_cls and nice_audit) in D:/ drive and need to move them to E:/ drive.

Accessing SSRS from a Web server

We have a Web server at our collocation site with public access. On the server, there is a simple menu with links that call SQL Server Reporting Services. We also have another server -- with SQL Server 2005 -- that contains our database and reporting services. This one is only on the internal...

Mirroring from a production environment to a DR environment

I have a production environment and a disaster recovery environment and each of them have two SQL 2005 servers in a cluster. We have two LANs -- the first one is our standard/everything LAN and the second is a Service LAN. We are looking to mirror from our production environment to our DR...