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
Native error 11 (Connecting via ADO)
Posted by Gaspar at 2/2/2006 10:35:18 PM
What is SQL native error 11?
I can't find info in BOL.
Deadlocks & Transaction Isolation Level
Posted by Amos Soma at 2/2/2006 5:09:37 PM
If I understand correctly, when using a Read Committed isolation level, the
most common reason for a deadlock is because two processes update a set of
tables in different order. However, it seems that when using a Repeatable
Read isolation level, the odds of a deadlock increase significantly.
Posted by Frank Rizzo at 2/2/2006 4:49:14 PM
I am battling various deadlocks on our system and have the trace flag
1204 turned on so that I get information on what was involved in the
deadlock. Today, however, I saw something that I've never seen before
(see below). What does 'Port' mean? How can I figure out what exactly
How the hell do you install SQL Server Management Studio for 2k5
Posted by Chris at 2/2/2006 3:20:31 PM
I have downloaded the full version standard SQL 2k5 server DVD from MSDN.
I have installed it.
I can find no what possible to get it to install the SQL Server Management
I have googled this and still haven't found the answer. I can't believe it
is this hard to actually get a GUI Adm...more >>
Posted by hershel at 2/2/2006 2:56:34 PM
I have a database In SQL server and I want to keep a log of all the
activityâ€™s that that the end user did I want to know who did and what he
did and when he did what is the bet way to keep track on that. In my previews
application I made a logs table with fields tableid, tablename, ...more >>
Backup and Restore
Posted by LaEsmeralda at 2/2/2006 2:26:39 PM
I need to backup 10 GB of data on the west coast and send over a dedicated T1
to restore on the east coast nightly. What is the best method?
Posted by Tim Harvey at 2/2/2006 2:07:07 PM
When I run a stored procedure on database (A) which is the same schema as
database(B) but with different data. The procedure takes painfully longer
that if I ran it on B which has more data. Does anyone have an idea as to
why this would happen and if there are any solutions that can be applied...more >>
Can I trap or log FATAL ERROR in a stored procedure?
Posted by Allan at 2/2/2006 1:14:57 PM
We have a stored procedure (sp1) calling another stored procedure (sp2).
Sp2 contains an insert statement following by a standard error checking using
@@ERROR (i.e. if @@ERROR <> 0, rollback...). However, when the insert
statement encounters a FATAL ERROR, the whole stored procedure cra...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
error handling flow
Posted by arthur at 2/2/2006 11:51:46 AM
i've got a stored procedure (a) that calls another stored procedure
(b). inside b i become a deadlock victim and i die. how can i "catch"
this in a? using if @@error <> 0 in a doesn't seem to work. also, i'm
using sql server 2003 so no try/catch. thanks!
Sql service pack 4. ( Very Slow...............)
Posted by Jazzman at 2/2/2006 11:09:26 AM
Server1: has SP3 and everything is running fine. I have a third party
that access this server and everything is moving fast.
Server2: Much better Server. Top of the line. Has SP4 installed.
I moved a few database for the third party application thinking that ...more >>
SQL backup to disk across the network failure
Posted by DB at 2/2/2006 9:46:27 AM
Firstly I am not a DBA. I am a systems guy trying to figure out why SQL
backups to disk across the network are failing.
The errors posted on the source server are attached below.
The problem is DEFINITELY NOT the network. We are absolutely 100% sure that
all network connectivity is good ...more >>
SQL Server 2000 crash and error
Posted by spoons at 2/2/2006 9:40:27 AM
SQL Server went down without any information in the log. When it came back
up, I was not able to connect using windows authentication. Instead, I have
to use SQL authentication. I have gone though the recommendations made by
Microsoft in article 840219 without success. Please help.
The e...more >>
Alert Response Execute Job
Posted by Thom at 2/2/2006 9:37:32 AM
I would like to have an alert execute a job as a response, but I also need to
have the error text passed into the job.
Is this possible or is there another way?
Restoring Files and Filesgroups
Posted by spoons at 2/2/2006 8:41:37 AM
I have a database with with two filegroups - the primary and one other.
Each filegroup has its own data file. I want to restore the database to a
different database server but restore only the primary filegroup.
When I try to do this, I get the following error for each of the data files
Logshipping out of sync
Posted by megabyte at 2/2/2006 8:40:34 AM
Every once in a while, my logshipping gets out of sync, the backup server
cannot restore. I found out that each time this happens, it is because on
the primary server about 17 tlog files get deleted, rather than the usual 1
file. The maintenance plan is set to keep files for 4 hours. IN the...more >>
Performance and data structure question
Posted by ibiza at 2/2/2006 8:36:40 AM
Hi SQL gurus,
I have a table structure question. I will have a table 'Models' that
has one to many 'incomes' and one to many 'costs'. These 2 entities
have exactly the same structure, which is 7 smallmoney and a name. Is
it better to create a table 'Incomes' and a table 'Costs', with both
how to: stored procedure with dynamic sql??
Posted by lai3288 NO[at]SPAM gmail.com at 2/2/2006 8:33:45 AM
will it be possible wirte a stored procedure with 2 input parameters:
include sql statement , insert into @destinationDB.dbo.tableA select
Enterprise Manager Problem
Posted by neeju at 2/2/2006 8:18:29 AM
Suddenly one of my user started seeing one problem.. Whenever he tries
to connect to database and see tables through enterprise manager. Gets
error as shown below.
"An unexpected error happened during this operation.
[MS Design Tools] - You might not have permission to perform this
difference between sql2k and sql2005
Posted by dk at 2/2/2006 7:29:52 AM
is there a good article or book or faq which highlights the
differences between sql2k and sql2005?
How check if constraint is enabled/disabled?
Posted by Mikael Be at 2/2/2006 7:28:59 AM
How do I check if a constraint is disabled or enabled?
Constraints have been enabled and disabled by
ALTER TABLE x NOCHECK/CHECK CONSTRAINTS ALL
but I like to see the status of the constraints....more >>
could not find table error message
Posted by Dan D. at 2/2/2006 7:28:56 AM
I run a script that tells me what tables need to be defragged. This query
gets a list of the tables:
WHERE TABLE_TYPE = 'BASE TABLE'
and then this query checks to see how fragmented the table is:
EXEC ('DBCC SHOWCONTIG (''' + @tablename...more >>
Using Case in Where Clause
Posted by mgx NO[at]SPAM mgxsolutions.com at 2/2/2006 6:58:53 AM
This is kind of an unusual problem that I am having. I am missing
something obvious. I just cannot figure out what it is.
Basically, here is what I am trying to do. This is a VB application
tapping into a SQL Server database. There is a table which contains 3
fields: ID, Like_Search and fld. A...more >>
Concatenating two floats with a comma in the middle
Posted by arun.hallan NO[at]SPAM gmail.com at 2/2/2006 6:07:02 AM
i am using the following code to try and get the following results:
convert(varchar,r.LowerStrike)+ ',' + convert(varchar,r.UpperStrike)
(for example) "100.22,44.5"
But i get the following error: Error converting data type varchar to
I assume sqlserver is trying to...more >>
Not enough storage is available to complete this operation
Posted by Heinrich at 2/2/2006 5:14:18 AM
Not enough storage is available to complete this operation" error message
when you run a Data Transformation Services package in SQL Server 2000
Any Ideas what to do or what the fix is
SQL 2005 - Unable to start service
Posted by mgale1 at 2/2/2006 4:15:44 AM
I am trying to run SQL Server 2005 Evaluation Edition on Windows Server 2003
Entreprise Edition SP1.
Until yesterday everything was running fine but today I am unable to start
the MSSQLSERVER service. The Analysis Services Service and the Integration
Services Service starts up fin...more >>
Ruling out OS - SQL Server Performance.
Posted by Meher at 2/2/2006 12:00:00 AM
I have a question hopefully the SQL Server Pros and MVPs would have an
answer for. Most of the time like any normal DBA to find performance issues
with SQL Server I make use of the performance counters through performance
monitor or system monitor and SQL Server Profiler and then rule o...more >>