Capture SQL Server logged in db User name in Access 2007 Accdb
I have a SQL Server 2005 backend with an Access 2007 Accdb front-end application.  Security has been established via SQL Server database user groups with associated table-level permissions. I would like to disable certain form functionality based on the logged in user.  Is there a way to ”capture the SQL Server logged in user name” in the Access code?  Probably in [...]

Answer Question   |  August 27, 2009  11:14 PM
Access 2007, Access 2007 security, Microsoft Access, SQL Server 2005, SQL Server 2005 security, SQL Server security

SQL Server Database Restore
When i restore a database from server1 to server2 as stand by/read-only mode the database restores with a database owner “domainrmartinez”. How can i restore a database from server1 to server2 and the database owner as “sa”?

Answer Question   |  September 4, 2009  9:21 PM
SQL Server, SQL Server 2005, SQL Server administration, SQL Server database, SQL Server database restore

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

Answer Question   |  August 24, 2009  7:42 AM
SQL Server 2005, SQL Server error messages, Vista, Windows Vista Home Premium 32-bit

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?

Answer Question   |  August 22, 2009  5:06 PM
SQL, SQL Server 2005, SQL Server 2005 performance

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.

Answer Question   |  August 18, 2009  2:11 PM
SQL Server 2005, SQL Server backup, SQL Server log shipping, SQL Server logs, SQL Server transaction logs

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

Answer Question   |  August 14, 2009  6:03 PM
SQL Server 2005, SQL Server Management, 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, [...]

Answer Question   |  August 13, 2009  2:56 PM
Access 2007, Microsoft Access, SQL Server 2005

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.

Answer Question   |  August 12, 2009  6:27 AM
SQL Server 2005, SQL Server stored procedures

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

Answer Question   |  August 11, 2009  6:32 PM
Access 2007, Access Database, SQL Server 2005, T-SQL, T-SQL Stored Procedures

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

Answer Question   |  August 6, 2009  2:00 PM
SQL Server 2005, SQL Server database

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 for [...]

Answer Question   |  April 13, 2010  11:25 AM
Active Directory, SQL Server 2005

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 due [...]

Answer Question   |  August 17, 2009  9:37 AM
SQL Server 2005, SQL Server replication

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. Material Pen Pen Link Pen Renolods I want ouput like CategoryName ———— Book Material

Answer Question   |  August 5, 2009  10:36 AM
SQL Server 2005, SQL Server Query, SQL Server tables

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 [...]

Answer Question   |  July 31, 2009  8:09 PM
Physical hosts, SQL Server 2005, SQL Server memory, Virtual Machines, vSphere

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

Answer Question   |  July 30, 2009  12:25 PM
SQL Profiler, SQL Server 2005, SQL Server Profiler

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 error converting IDENTITY to data type bigint. Arithmetic overflow occurred. Is there a way [...]

Answer Question   |  July 27, 2009  10:15 AM
SQL Server 2005, SQL Server 2005 (32-bit)

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 [...]

Answer Question   |  July 24, 2009  9:35 AM
obi, OBI EE, ODBC, SQL Server 2005

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 [...]

Answer Question   |  July 24, 2009  10:15 AM
SQL queries, SQL query optimization, SQL Server 2005

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?

Answer Question   |  July 16, 2009  4:35 PM
SQL Express, SQL Server 2005, SQL Server 2008, SQL Server Training

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.

Answer Question   |  July 9, 2009  4:20 PM
SQL Server 2000, SQL Server 2005, SQL Server Database Migration, SQL Server databases