• Local clients loose connection to local SQL Server when system network drops connection to HQ.

    When line to primary Domain controller is dropped, some of the current logged on clients are dropped by SQL when they try to access the database.  For some clients, the application still works just fine. The clients are all set up and authenticated in the local Domain Controller. It is my thought...

    TomHelm5 pointsBadges:
  • Moving Distribution database from an instance to antother does increase performance ?

    The Publisher database is in use by nearly 300 users with a trafic of about 340trans/sec. After adding replicas with a [strong]push[/strong] subscription (transaction replication with queue mngmt) to 1 subscriber (15 users) the CPU need on the server moved from 25% to about 55% and I can see some...

    AGiachetti5 pointsBadges:
  • Running SQL Server 2000 and 2005 simultaneously

    When simultaneously running SQL Server 2000 and 2005, what performance effects can I expect this having on the box? Should the memory be increased? And what can I do now to fine-tune it before the install of 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • ASP.NET

    i want to insert the data into the existing database

    5555544425 pointsBadges:
  • Multiple rows locked in sqlserver when updating one row

    In Microsoft SQLServer, I found out that when you perform an SQL update, in a lot of cases multiple rows are locked, even when row-locking is configured for that table and page-locking is prohibited, and even when you force row-locking in the SQL statement using WITH (ROWLOCK).

    Nevenfi5 pointsBadges:
  • Microsoft Visual Studio 2008 Express edition

    Hello everybody, i recently downloaded the Microsoft Visual Studio 2008 Express Edition. It has Visual Basic 2008, Visual C# 2008, Visual C++ 2008 and Visual Web Developer 2008 (all Express editions). The problem is i dont know where to start. I have programming background. i have programmed in C++...

    GK30 pointsBadges:
  • SQL server STD 05 between Sites

    besides buying Enterprise($$$$$.$$), how else can I keep these servers (sych'd, mirrored, ???) via a network link between cities? Server1(win-sql-05)DB <> Server2(win-sql-05)DB

    Multilanguage25 pointsBadges:
  • Procedure cache ratio calculation in SQL Server?

    Hi, Does anyone know how to calculate the procedure cache ratio in SQL Server 2005 by selecting specific table in SQL Server? Thanks.

    Db23290 pointsBadges:
  • SQL Server 2005 error log, could not read information for this log entry

    Hi, There is a SQL Server error log entry in the SQL Server 2005 production box with the following.   "Log Viewer could not read information for this log entry. Cause: Data is Null. This method or property cannot be called on Null values.. Content:"   Has anyone seen anything similar? Does anyone...

    Db23290 pointsBadges:
  • Create Excel file on web server by using SQL

    How can I create an excel sheet on web server by using a stored procedure in SQL Server 2005. I'm retriving data from sql select query and creating Excel file dynamically on we server of that data using asp.net. But I want to do this with the help of SQL stored prcedure. i.e. In a stored procedure...

    SwapnilD25 pointsBadges:
  • View t-sql SPID is executing

    Is there a table that I can query to view what sql statements a spid is running? I do not want to use the dbcc inputbuffer.

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

    Teamwork085 pointsBadges:
  • Access Rights in SQL Server 2005

    Hi,  I'm using sql server 2005 and in my application i have 2 DB say A and B , and 2 servers SR1,SR2 and DB A,B and present on both (SR1,SR2).now i want to give access to users entering my DB not to view any of the entries made in the DB, not even the Tables created in my DB...pls provide me Step...

    ENGG66615 pointsBadges:
  • bcp – clock time meaning

    Attempting to BCP a large resultset using a view and the queryout option. I have been playing with the network packet size and the size of the batche using join conditions. When looking at the command line output file. What do the values in "Clock Time (ms.) Total" signify. I am trying to measure...

    Joetig35 pointsBadges:
  • SQL Server Express 2005 Installation Failure

    Here is a fix for SQL Server Installtion failure. And a fix for newly installed programs that cause memory faults. I encountered an issue after installing SQL Server Express 2005. Where I get a blue screen with c000021 0xc0000005 this is an install on a Dell PowerEdge 600SC Widows XP SP2. To...

    Baristador5 pointsBadges:
  • 32 and 64 Bit SQL 2005 on Same Server

    We need to still link to MS Access databases and understand the 64 bit SQL Server does not allow. So, a thought is to have the new 64 bit SQL Server coexist with a 32 bit SQL Server Express instance. The thought is the 32 bit instance will enable linked server access to MS Access databases. We...

    MxPerry25 pointsBadges:
  • SQL 2005 Password

    I inherited SQL 2005 server from a previous employee and the SA password is currently stored and saved in the GUI. This has allowed me to do my job up until now. I have what I think to be the password but I am unsure if it is correct. I am afraid to remove the stored password to check. Is there an...

    Jabbman4220 pointsBadges:
  • sql server express 2005 cannot see drive on my server (drive q)

    I have installed sql server express on my local computer and now I would like to install it on the server (q). When I go to install it, it is not seeing the q drive. What could be causing this?

    Shircol25 pointsBadges:
  • SQL Server 2005 Performance optimiztion

    I have the following setup, would like to know what's best for log files, data files, indexes, tempdb files. Also, since the server is used solely for SQL 2005 Reporting Services, how many tempdb data files and tempdb log files should I create, also how many userdb data files and userdb log files....

    ITKE413,620 pointsBadges:
  • SQL Server 2005 Error Registering database

    I try to copy SQL Server 2005 Database to VISUAL Jobshop (ERP INFOR) get message when VJS DB Wizard of Jobshop tries to create catalogue tables "Error registering database - operation is not allowed when object is closed" Thanks for help where I have to look to solve that problem.

    ITKE413,620 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.

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

Following