Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
server side tracing to table or file and how safe on high OLTP system?
Posted by Hassan at 2/24/2006 8:24:46 PM
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
Question about joining 2 tables????
Posted by Wing at 2/24/2006 4:48:38 PM
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".
Getting a Server is not known to be running message
Posted by Chris Wood at 2/24/2006 4:45:39 PM
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 >>
Multiple tables or one large table
Posted by Sierra at 2/24/2006 4:27:27 PM
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.
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 >>
Set up linked server between SQL 2005 and SQL 2000?
Posted by Jamie at 2/24/2006 4:23:25 PM
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 >>
Power went out -- how to check consistency, etc.?
Posted by HK at 2/24/2006 3:51:31 PM
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?
Moving physical Data file
Posted by Jay at 2/24/2006 3:37:17 PM
In SQL SERVER 2000 i have 2(two) database at Drive D:\ & i want to move to
How i can move from ISQLW....more >>
Removing access to see Stored Proc contents.
Posted by ChrisR at 2/24/2006 2:37:39 PM
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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
Need help with CDONTS or other object to receive mail in a specific way
Posted by Vanessa Lee at 2/24/2006 2:26:07 PM
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 >>
Running SQL Mail in developers edition
Posted by MarkAurit at 2/24/2006 2:23:27 PM
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 >>
Any idea where SQL store the synonyms? thanks
Posted by davidw at 2/24/2006 2:02:06 PM
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.
how to check if server is replicating
Posted by David at 2/24/2006 1:41:26 PM
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 >>
.MDF recovery after data failure
Posted by t-o-m-h-VA at 2/24/2006 1:36:27 PM
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 >>
Posted by Rustom at 2/24/2006 1:35:16 PM
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?
Finding a query submitted by software
Posted by Scott Ford at 2/24/2006 12:50:27 PM
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 >>
Job status is not updating
Posted by Yuras at 2/24/2006 12:12:36 PM
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.
distributed transaction MSQL<->oracle
Posted by jreategui NO[at]SPAM gmail.com at 2/24/2006 11:55:46 AM
I'm trying to execute this:
create table #tt (nro_parte_erp varchar(50))
declare @query as varchar(4000)
declare @estado as char
set @query =3D'
from BAAN.ORDENES_102 a,baan.set_o...more >>
Q: creating replication of the system
Posted by JIM.H. at 2/24/2006 11:39:22 AM
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 >>
What services are required to run on SQL Server 64 bit Active/Passive cluster
Posted by imarchenko at 2/24/2006 11:35:05 AM
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 =
Can we declare a Table in a FUNCTION.................?
Posted by Dutt at 2/24/2006 10:24:18 AM
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.
Posted by BenUK at 2/24/2006 9:35:08 AM
I've been tasked at looking into a solution for a global data project for my
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 >>
Event log error after SQL 2005 developer install
Posted by Jim H at 2/24/2006 9:33:35 AM
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=220.127.116.11,
Culture=neutral, ...more >>
How to defrag an SQL 7 AND 2000 server?
Posted by Clayton Sutton at 2/24/2006 9:26:03 AM
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 >>
median query without using function
Posted by uspensky NO[at]SPAM gmail.com at 2/24/2006 9:09:19 AM
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 >>
Full Text Search in SQL Server 2000
Posted by Lee at 2/24/2006 8:39:15 AM
I'm having trouble retrieving results from a SP that uses the Contains
or FREETEXT functions.
CREATE PROCEDURE dbo.bugFuzzySearchDesc
SQL Server 2005 configuration manager
Posted by c_shah at 2/24/2006 7:35:31 AM
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..
ReIndex with fillfactor of 100
Posted by kghammond at 2/24/2006 7:15:20 AM
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 >>
Updating a table name throughout a database...
Posted by Paul Daly (MCP) at 2/24/2006 6:21:27 AM
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
In-place upgrade vrs. Side-by-side migration
Posted by Flora Seymour at 2/24/2006 6:19:27 AM
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 >>
Sql express 2005 Free space problem
Posted by aurels at 2/24/2006 5:54:27 AM
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 >>
Enterprise Manager not displaying Bigint's
Posted by Russell at 2/24/2006 4:27:13 AM
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 >>
SQL Server Service
Posted by Mike at 2/24/2006 2:15:27 AM
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?
SQL 2k5 Enterprise Edtion
Posted by Syed at 2/24/2006 12:58:26 AM
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
My question is:
Do we need Enterprise edtion or we can use standard edtion as well?
If you say, I need Enterprise Editio...more >>
Interview Questions Feb 24, 2006
Posted by Jobs at 2/24/2006 12:25:14 AM
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 >>
sql to html
Posted by wesleym312 at 2/24/2006 12:20:42 AM
Hi guys, i want to convert my sql table into html and later on to pdf.
Can any of you guys help me?
SQL Server Express Attach
Posted by elziko at 2/24/2006 12:00:00 AM
I am trying to create a conneciton to an SQL Server Express database from
..NET. Here is my connection string:
Security=True;Connect Timeout=30;User Instance=True'
However, I get the following error:
'An attempt to ...more >>
Delegation stops working after a while
Posted by Mattias at 2/24/2006 12:00:00 AM
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
@ and @@ in a trigger
Posted by Jason Huang at 2/24/2006 12:00:00 AM
I saw the @ and @@ in a SQL Server trigger, would some tell me what they
Thanks for help.
SQL Server 2005 questions
Posted by maxzsim via SQLMonster.com at 2/24/2006 12:00:00 AM
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 >>
Out of control log file
Posted by Steven Johnston at 2/24/2006 12:00:00 AM
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 >>
char vs varchar - reclaiming free space
Posted by DRagan Matic at 2/24/2006 12:00:00 AM
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 >>
Posted by maxzsim via SQLMonster.com at 2/24/2006 12:00:00 AM
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
trigger for updating another row in a same table
Posted by Jason Huang at 2/24/2006 12:00:00 AM
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 >>
xp_sendmail: error 0x80004005
Posted by Jesus Suarez at 2/24/2006 12:00:00 AM
This error send emial via sendmail. why?
Posted by tomtaharn at 2/24/2006 12:00:00 AM
I have a table with at least two columns. My target is to create an new
table/view containing per row
key | profile1 | profile2 | profile3 |
1 | ellen ...more >>
Column's default value in 2005
Posted by angi at 2/24/2006 12:00:00 AM
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!