We have brought our application down when running the GUI Profiler on a highly transactional SQL server. I want to start capturing all data for trending,etc.. I am just afraid I may bring the system down again. I was thinking of just the base events of RPC:completed and SQL: Batch Comple...more >>

Hi everyone, I have problem to join 2 tables together to show the selected results into a datagrid. table1 hosts all customer personal information. table2 hosts all the trasaction records for each customer table1 has fields such as "customerID", "CustomerName" and "TelNumber". (customerI...more >>

Hi, We just updated our SQL2000 build 818 servers from W2K3 to W2K3 SP1 and now from an SP3A SEM on an XP SP2 workstation, the little Green Triangle does not show and you might get a Server is not known to be running message when you try to connect. What did W2K3 SP1 change for this to happ...more >>

What are the performance considerations for deciding whether to have multiple table sets or a single large table set with a key in each row. Details: SQL Server 2005 We have an application that uses 20 or so tables but will likely grow into the small hundreds. We will potentially have hundr...more >>

Hi, there, We have two SQL server, one is running SQL Server 2000 (named as SQL1) and another is running SQL Server 2005 (named as SQLTEST). Both are on Windows Server 2003 Server. I want to set up linked server between them, so the developers can run distributed query from their machine...more >>

The power went out to a live SQL Server. UPS was being serviced (that figures) and thus the server simply lost all power. Now what? How do I check for consistency? Will checking consistency take the database down (like some dbcc things)? What else should I do/check? ...more >>

In SQL SERVER 2000 i have 2(two) database at Drive D:\ & i want to move to Drive E:\. How i can move from ISQLW....more >>

Howdy all. I have a 3rd party vendor (sort of) that needs to know a login and password on a SQL server for a DB he will be accessing. He only needs to have the ability to exec Stored Procs (SP), not write directly to tables. The problem that Im having with this though is that I: 1; Create a...more >>

Hello, Is it possible to write a script using CONDTS object to read all emails from the SMTP IIS "Drop" folder without changing the username and email address in LogonSMTP? or is there completely another way to do it. Here is what I want exactly the program to do: I just want to have one sc...more >>

We have SQL Mail running on our servers, but Im often offline during development (although my machine is on the internet). Can SQL Mail be configured to run locally in SQL Server 200 Developers Edition? The configuration docs for pop accounts are confusing in that regard (at least to me), ...more >>

I need read defination of my synonyms, but I could not find which system table it stores, I know they get one entry in sysobjects table, but I have no idea where is the defination. Thanks! ...more >>

Hello, I want to check if a sql server is involved in replication. I can check by looking in EM at LinkedServer icon. But is there any system SP that will give info if the current server is subscriber to any other SQL Server Thanks in advance...more >>

Hi, I recently had a problem with a database which resulted in restoring the database from backup. The .mdf and .ldf files were restored, however I could not reattach the database. I attempted to create a new database, stop SQL Server, and copy over the ..mdf and .ldf files which put th...more >>

I have a Windows 2003 Enterprise server with 6GB or Memory. The boot.ini is using the /3GB /PAE switches. Do I need to set SQL AWE to enabled and use the MAX Memory option in order for SQL to use the memory above 4gb? ...more >>

I have a retail software that has a reporting function for its sales. It has a SQL Server 2000 database. The table links are extremely hard to define, and I want to be able to write custom reports. If I can see the query that it submits I can figure out how to make my own reports for it. Is th...more >>

Hello all, I have a strange and annoying problem with SQL Server 2000 SP3 (I can't upgrade to SP4 at this moment.) I have a maintenance plan consisting of three scheduled jobs. Starting couple of weeks ago the Agent fails to update the last execution time and job outcome for these jobs. ...more >>

I'm trying to execute this: create table #tt (nro_parte_erp varchar(50)) declare @query as varchar(4000) declare @estado as char set @estado=3D'1' set @query =3D' select nro_parte_erp=3D nro_parte from openquery(desarrollo_baan,'' select nro_parte, from BAAN.ORDENES_102 a,baan.set_o...more >>

Our APS.Net eCommerce application runs on a web server that reaches SQL Server in our network. We are looking for options to have two different web servers and Database servers so that if we have a problem in one web server or a database server, the other will still continue to serve our clien...more >>

Hello! I came across an error message in Application Event log on our SQL = Server 2005 64-bit Active/Passive cluster: Failed auto update retrieval of third-party root list sequence number = from: = <http://www.download.windowsupdate.com/msdownload/update/v3/static/truste= dr/en/authrootse...more >>

Hi, I have a doubt regarding functions in MS SQlServer 2000. Can we declare ,use and drop a temperory table in the function body? Its showing suntax error. Thanks & Regards. ...more >>

Hi All, I've been tasked at looking into a solution for a global data project for my company. The company uses some software that requires a local database, the local databases are going to be located in Australia, US, & UK, the local databases will have exact copies of each others schem...more >>

I get the following errors in my application event log on each reboot after installing SQL Server 2005 developer edition. ..NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0, Culture=neutral, ...more >>

Can someone tell me how to defrag. an MSSQL 7 AND MSSQL 2000 server. We have both ver. 7 and 2000 (running on two different systems). I am not a DBA but I really need to get this done tonight (2/24/2006) while we take our systems down. I will also want to defrag the Windows 2000 and Windows...more >>

I have a table (cars) with 3 fields: VIN, Class, sell_price 101, sports, 10000 102, sports, 11000 103, luxury, 9000 104, sports, 11000 105, sports, 11000 106, luxury, 5000 107, sports, 11000 108, sports, 11000 109, luxury, 9000 i need to write a query that WITHOUT USING A FUNCTION wil...more >>

I'm having trouble retrieving results from a SP that uses the Contains or FREETEXT functions. CREATE PROCEDURE dbo.bugFuzzySearchDesc @SearchTerm varchar(2048) AS SELECT issue_id, issue_description FROM bug_issues WHERE FREETEXT(issue_description, @SearchTerm); ...more >>

I know the answer but what's difference between Surface Area Configuration and configuration manager..Why there are two places for setting configration..? I always get confused.. ...more >>

Our results of reindexing with a fillfactor of 100% for a read only database are surprising: Here is before using a fillfactor of 100%, the previous fillfactor was 90% and had some inserts and updates since the last reindex: DBCC SHOWCONTIG scanning 'RNUMBER' table... Table: 'RNUMBER' (206575...more >>

I was wondering if the following feature is available. If I want to change the name of a table, but I have a TON of stored procedures that are pointing to that table, is there a way to change the name of the table and update all of the stored proceedures that point to the old name? Thank...more >>

Hi We are about to do our first SQL Server upgrade ( from SQLServer200sp3a to SQLServer 2005). For server upgrades (e.g. W2000 to W2003) we always rebuild the server since we find this approach much cleaner then an in-place upgrade. I am wondering if this is true for SQLServer as well. On...more >>

Hello, I m using on a same server 1 msde and 1 sql express 2005 (1 instance each) on a partion with 9gb of free space. When I click on the properties I'm using , for the msde instance (Wsus db) 337 mb , and I have only 8.5 Mb of Free space For the sql Express I'm using (Mom Worgroup db...more >>

I am currently having an issue on one of our pc's here in SQL 2000 Enterprise Manager, whereby if you do a return all rows on a table that contains a bigint column it show as blank. Yet if you do a select * from query analyzer it is displayed correctly....more >>

Hi: When sql server service stops and restarts again other than manually doing it or restarting the server. Does or can it happen on a set schedule, for example, nighly basis? Thanks...more >>

hi everyone, Our company planning to develop a web application for our client who login to the application and enter few details and get quotation for Life re-insurance. My question is: Do we need Enterprise edtion or we can use standard edtion as well? If you say, I need Enterprise Editio...more >>

What is Native Image Generator (Ngen.exe)? The Native Image Generator utility (Ngen.exe) allows you to run the JIT compiler on your assembly's MSIL and generate native machine code which is cached to disk. After the image is created .NET runtime will use the image to run the code rather th...more >>

Hi guys, i want to convert my sql table into html and later on to pdf. Can any of you guys help me? Thanks wes ...more >>

I am trying to create a conneciton to an SQL Server Express database from ..NET. Here is my connection string: 'Data Source=.\SQLEXPRESS;AttachDbFilename="c:\database.mdf";Integrated Security=True;Connect Timeout=30;User Instance=True' However, I get the following error: 'An attempt to ...more >>

I have a linked server set up between two servers (A & B). Server A is running 2005 and Server B is running 2000. Both servers SQL services are running using a domain user account and have their SPN's registered in the AD. The client connects to Server A using integrated security (TCP/IP and ...more >>

Hi, I saw the @ and @@ in a SQL Server trigger, would some tell me what they are? Thanks for help. Jason ...more >>

Hi All , I am not using SQL Server 2005 yet but would like to know the followings : 1. MDX & data analysis Is there any difference in writing MDX expressions now in the new the analysis services ? 2. Database mirroring Is this the same as clustering for SQL Server2000 together ...more >>

To all: I have a database that's about 2.5 GB in size, but the log file has grown to over 55GB and has eaten up almost all of my drive space. How can I remove/replace/compress that log file to recover my hard drive space back? I've tried recreating the log file by running sp_detach_db, crea...more >>

One of our customers is using MSDE2000 and has reached 2 gb limit. After erasing some old data and shrinking database he still had 1938 mb allocated. After that, I have noticed that some of the larger tables (around 1,5 - 2 million rows spread across a few tables) had column defined as ch...more >>

Hi , May i know the link to SQL Server 2005 newsgroups ? and also is there a newsgroup for Visual Web Developer & VB.NET ? tks & rdgs -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200602/1...more >>

Hi, Saying in my table Table1, there're two datarow like this: ID RefNo CustNo CustAddr Product 1 200001 12345678 LA Apple 2 200001 12345678 LA Orange 3 700008 88888888 Ca Rose Not the row1's CustNo and CustAddr is changed to 2345678...more >>

Hello, This error send emial via sendmail. why? ...more >>

Hello all, I have a table with at least two columns. My target is to create an new table/view containing per row before key | profile1 | profile2 | profile3 | ------+-------------------+-------------------+-------------------+ 1 | ellen ...more >>

HI, Dose column's default value can be set as 2 columns' "+, - , *, / " ? I want ColumnC's default value as ColumnA/ColumnB. Any idea? Thanks for any advice! Angi ...more >>