What is SQL native error 11? I can't find info in BOL. Thanks. ...more >>

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. ...more >>

Hello, 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 ...more >>

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 Studio. 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 >>

Hi 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 >>

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? Thanks. LaEsmeralda...more >>

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 >>

Hi, 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 >>

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! arthur ...more >>

Strange situation: Server1: has SP3 and everything is running fine. I have a third party application 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 >>

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 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 >>

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? ...more >>

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 ...more >>

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 >>

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 the...more >>

will it be possible wirte a stored procedure with 2 input parameters: sourceDB, destinationDB include sql statement , insert into @destinationDB.dbo.tableA select from @sourceDB.dbo.tableA?? Regards, Jackie ...more >>

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 operatio...more >>

is there a good article or book or faq which highlights the differences between sql2k and sql2005? tia, dk...more >>

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 >>

I run a script that tells me what tables need to be defragged. This query gets a list of the tables: SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' and then this query checks to see how fragmented the table is: EXEC ('DBCC SHOWCONTIG (''' + @tablename...more >>

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 >>

i am using the following code to try and get the following results: convert(varchar,r.LowerStrike)+ ',' + convert(varchar,r.UpperStrike) to get: (for example) "100.22,44.5" But i get the following error: Error converting data type varchar to float. I assume sqlserver is trying to...more >>

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 HH...more >>

All, 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 >>

Hi: 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 >>