Search Results

Search found 27339 results on 1094 pages for 'sql dmv'.

Page 120/1094 | < Previous Page | 116 117 118 119 120 121 122 123 124 125 126 127  | Next Page >

• How to install SQL Server 2005 evaluation on Windows XP?

  - by Cute

  I am frustated because when I try to install the evaluation edition of SQL Server 2005 it shows only the books online check box. I have installed Visual Studio 2003 first and the .NET framework 2.0 SP1.

  Read the article

• How do you find the name of an existing full text catalog in SQL Server 2008 Express?

  - by Kyle Noland

  I have SQL Server 2008 Express installed. Several months ago I created a full text catalog and index. I would like to index some additional table columns now, but I can't remember the name of the existing catalog. How do I find out the name of an existing full text catalog. Hopefully this doesn't involve installing any new tools, because this…

  Read the article

• Is there a command line script I can use to check if servers have SQL Server 2008 DMO installed?

  - by ddono25

  SQL Server 2008 does not install DMO by default. Is there a function or script I can use from the command prompt to check remote servers to see if DMO has already been installed? We were using a registry key check but thought that might not be the best option. Any advice is appreciated!

  Read the article

• Two clustered SQL instances on one cluster - same port 1433?

  - by Sam

  Can two clustered SQL instances on a 2003 windows cluster use the same 1433 tcp port setting reliably? It seems to be up and working right now.

  Read the article

• Best way to backup a SQL Server database nightly?

  - by Urda

  What is the best way to backup a SQL Server 2005 database nightly? I'm looking for a solution/strategy that would make the database backup file, and place it in an "outgoing" directory. We're wanting our FTP software to move it out to an offsite server. Any suggestions on how to make this work as desired?

  Read the article

• How do I automatically run nightly backups for Microsoft SQL Server 2005?

  - by cowgod

  I don't see any built in mechanism for scheduling nightly backups in SQL Server 2005. What tools are available to perform this task and how reliable are they?

  Read the article

• What is the best way to determine what's locking up SQL Server using a query?

  - by Aplato

  Recently our SQL Server is getting bogged down by something. I was wondering what is the best way to check what could be causing the problem by querying the database. This is the best I've found so far: SELECT SPID = s.spid , BlockingSPID = s.blocked , DatabaseName = DB_NAME(s.dbid) , ProgramName = s.program_name ,…

  Read the article

• What should I do about SQL connections that is a Head Blocker?

  - by MartinHN

  I'm looking at the Activity Monitor in SQL Server 2008 Management Studio. I see that a lot of processes indicates that it is a blocking process, by the value of 1 in the Head Blocker column. Is this normal, or am I potentially dealing with an issue here?

  Read the article

• How To Delete Top 100 Rows From SQL Server Tables

  - by Gopinath

  If you want to delete top 100/n records from an SQL Server table, it is very easy with the following query: DELETE FROM MyTable WHERE PK_Column IN(     SELECT TOP 100 PK_Column     FROM MyTable     ORDER BY creation    ) Why Would You Require To Delete Top…

  Read the article

• Issue Creating SQL Login for AppPoolIdentity on Windows Server 2008

  - by Ben Griswold

  IIS7 introduced the option to run your application pool as AppPoolIdentity. With the release of IIS7.5, AppPoolIdentity was promoted to the default option.  You see this change if you’re running Windows 7 or Windows Server 2008 R2.  On my Windows 7 machine, I’m able to define my Application Pool Identity and then create an associated…

  Read the article

• Writing A Transact SQL (TSQL) Procedure For SQL Server 2008 To Delete Rows From Table Safely

  In this post, we will show and explain a small TSQL Sql Server 2008 procedure that deletes all rows in a table that are older than some specified date.  That is, say the table has 10,000,000... This site is a resource for asp.net web programming. It has examples by Peter Kellner of techniques for high performance programming...Did you…

  Read the article

• Linq to SQL Lazy Loading in ASP.Net applications

  - by nikolaosk

  In this post I would like to talk about LINQ to SQL and its native lazy loading functionality. I will show you how you can change this behavior. We will create a simple ASP.Net application to demonstrate this. I have seen a lot of people struggling with performance issues. That is mostly due to the lack of knowledge of how LINQ internally…

  Read the article

• Removing Duplicate Data From SQL Query Output For Display On A Web Page [migrated]

  - by doubleJ

  I had asked a similar question on stackoverflow but didn't really get anywhere. This page shows the output that I'm currently getting from my MSSQL server. I have a table of venue information (name, address, etc...) that our events happen on. Separately, I have a table of the actual events that are scheduled (an event may happen…

  Read the article

• SQL SERVER Spatial Database Queries What About BLOB T-SQL Tuesday #006

  Michael Coles is one of the most interesting book authors I have ever met. He has a flair of writing complex stuff in a simple language. There are a very few people like that. I really enjoyed reading his recent book, Expert SQL Server 2008 Encryption. I strongly suggest taking a look at it. This [...]...Did you know that…

  Read the article

• Calling MSSQL stored procedure from Zend Controller ? Any other approaches?

  - by Bhavin Rana

  MSSQL and DB, Zend as PHP Framework, I am using this way to call SP with I/P Parameters and to get O/p Parameters. It seems I am writing SQL code in PHP. Any other good approaches? $str1 = "DECLARE @Msgvar varchar(100); DECLARE @last_id int; exec DispatchProduct_m_Ins…

  Read the article

• Using Sql Server Change Data Capture with a frequently changing schema

  - by Pete

  We are looking into enabling Sql Server Change Data Capture for a new subsystem we are building. It's not really because we need it, but we are being pushed for having a complete history traceability, and CDC would nicely solve this requirement with minimum effort on our…

  Read the article

• Run a .sql script file in C#

  - by SAMIR BHOGAYTA

  using System.Data.SqlClient; using System.IO; using Microsoft.SqlServer.Management.Common; using Microsoft.SqlServer.Management.Smo; namespace ConsoleApplication1 { class Program { static void Main(string[] args) { string…

  Read the article

• query to select topic with highest number of comment +support+oppose+views

  - by chetan

  table schema title description desid replyto support oppose views browser used a1 none 1 1 12 - bad topic b2 1 2 3 14 sql database a3 …

  Read the article

• SQL SERVER SHRINKFILE and TRUNCATE Log File in SQL Server 2008

  Note: Please read the complete post before taking any actions. This blog post would discuss SHRINKFILE and TRUNCATE Log File. The script mentioned in the email received from reader contains the following questionable code: “Hi Pinal, If you could remember, I…

  Read the article

• PrestaShop install SQL error

  - by Steve

  I am trying to install PrestaShop 1.4.0.17, and reach Step 3. I enter database information, which tests okay, and I choose the second option: Full mode: includes 100+ additional modules and demo products (FREE too!). I choose Next, and receive the error: …

  Read the article

• SQL binary value to PHP variable leading zeros

  - by Agony

  Using sql query to pull data from a mssql database results in a value that still has leading zeros. The data in database is stored as binary(13) - so it will pull all 13 digits. However the value is a text, so any leading zeros will generally show up as…

  Read the article

• Express5800 to Mesh with SQL Server 2012

  NEC's GX servers have been engineered to supply high performance and availability. At their core is an Intel Xeon E7 processor with the power to handle up to 2TB of memory and 160 threads. In addition, thanks to QuickPath Interconnect technology, GX…

  Read the article

• SQL Server Requery() sometimes hangs

  - by PSU

  I have an issue with Visual C++ and Microsoft SQL Server 2008R2. The following code will occasionally hang: Object->Update(); if(Object->CanRestart()) { //Why does this not return?? m_pDBRoRBaseObject->Requery(); } …

  Read the article

• SQL Server Agent was not running on Server Dynamics CRM 2013

  - by No1_Melman

  I'm trying to install Dynamics CRM 2013 on a server. This server is on a VM. There are several other VMs, an ADDS & DNS, a MSSQL and a WebServer VM. Each server is a Windows Server 2012 R2. The SQL Server is 2012 Enterprise. Each VM is part…

  Read the article

• ERROR [01000] [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect())

  - by Steven Morrison

  Our company had resently upgraded to a domain functionality from workgroup and now we get this error message shown below on the clients laptops. The software on the server is working as it was opening the SECWARE application and a successful…

  Read the article

< Previous Page | 116 117 118 119 120 121 122 123 124 125 126 127  | Next Page >