• SQL Database User

    Hello, I have 3 servers running sql server 2005 server1, server2, and server3 with database1 and database2 respectively. I backup database1 on server1 and backup database2 on server2 then I restore database1 and database2 on server3 as read-only on a daily basis. I only want to use one sql...

    Rick Martinez585 pointsBadges:
  • Applying snapshot on Subscriber – SQL SERVER 2005

    hi, i've read on this articlehttp://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1362610_mem1,00.html about applying snaphot on the subscriber by copying the snapshot on the distributor and sending it to the subscriber. i didnt get what/how this part.  When the snapshot is created and the...

    Raptur3d5 pointsBadges:
  • Controlling tempdb Growth

    I have a user running a SAS job that kicks tempdb from 8.5M to 6.6Gig in less than ten minutes. tempdb is on the default C: partition, which is only 16G (I have no control over that ridiculous size)! I’m new at this so I’m thinking my only option is to MOVE tempdb because of the space...

    VelameLaCosa110 pointsBadges:
  • 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"?

    Rick Martinez585 pointsBadges:
  • Is share point an alternative / more than SQL Server?

    I m poor in using MOSS Microsoft Office Share Point. I have web application in ASP using IIS and SQL Server 2005. Now if I have no licence for SQL Server 2005 can I use MOSS as an alternative for SQL Server 2005? Is it possible to create / attach data base in MOSS / MOSS related SQL...

    SQLServer200810 pointsBadges:
  • Service Broker in sql server 2005

    [strong]What is a real life application of service broker architecture in sql and how to use it?[/strong] [strong]Can anybody help me in understanding service broker with real life example?[/strong] Thanks in advance

    Srm20095 pointsBadges:
  • 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...

    Ppeterso15 pointsBadges:
  • Migrating C code db acess from sybase to sql server 2005 – newbie

    I have to change the db access from a sybase to a sql server 2005 in a c program (i have to keep the C code) I have read lots of technical articles but i'm a bit confused ... with ODBC and the use of sqlcli.h i write a simple C code that access the sql server db but i think it is not the better...

    0949595 pointsBadges:
  • 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

    Rishabhshukla5 pointsBadges:
  • 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?

    Rick Martinez585 pointsBadges:
  • 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.

    Rick Martinez585 pointsBadges:
  • 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...

    DNG55 pointsBadges:
  • 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

    Cabrini5 pointsBadges:
  • 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,...

    NHSNick30 pointsBadges:
  • 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.

    Jsql155 pointsBadges:
  • 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

    DamMan5 pointsBadges:
  • 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

    Zippyyepee15 pointsBadges:
  • 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...

    Kotnimahesh5 pointsBadges:
  • 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...

    SKrep5 pointsBadges:
  • 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

    Jsql155 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following