Top Solutions

SQL 2005 Error. No clue what this means. Any insight is appreciated.

Msg 1205, Level 13, State 56, Line 35
Transaction (Process ID 51) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun...

Hi Experts,
I have a single SQL Server 2005 (running on Server 2003 std) which refuses to install SP4.. I have pasted the logs and the "SQL9_Hotfix_KB2463332_sqlrun_sql.msp.log" it refers to in the event log as an attachment.

I have searched...

Last Thursday, we got attacked by SQL Injection attack ... several tables in one of our production DBs had the following string inserted at the begining of each row:

></title><script src="lilupohilupop"></script><!-

The above string was...

I am currently doing a Backup Plan for my Databases.(FULL Mode)

I have a database of 28MB but its log file is around 8000MB! How will i manage to clear the Logs?

I tried the following:
1. Full backup of the Database.
    (Size of Full...

How many collations does SQL Server 2005 support in all? Is it more in 2008?

thanks

I have a SQL Server 2005 database, and it's data and log files reside on drive E:\

Hey is there an easy way to move the database (mdf, ldf) files from one drive to another?

What would be the steps?

Thanks.

We have a new report in SQL Server 2008 reporting services that was built using the SQL Server reporting services 2008 Report Builder.  The report points at an analysis services cube data source/model.  The report is saved and when I attempt to...

Hello
The service SQL Server ACtive Directory Helper (Auto Start Service) has stopped running, when I go into Services in the MMC and try to manually start it I get the following error:
"Windows could not start the SQL Server Active Directory...

I can't telnet into port 1433 going from A to B,  but I can from B to A...

I have an XP Pro SP3 box and a Win2003 Server, each running MS SQL Server 2005, the XP Pro box running Express, the 2003 Server running the full edition.

Anyway,...

Msg 3930, Level 16, State 1, Line 49
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.


what does this mean?

I have a SQL Server that has been working fine for the past year.  But all of a sudden when I rebooted my server I got this error:

"The SQL Server (TESSI2005) service terminated with service-specific error 17058 (0x42A2)."

 Everything that...

we just virtualized our sql server development box and installed SQL Server 2005 standard edition.  Previously we were running sql server 2000.  We moved over all the databases and I setup the logins for the database...same as they were before.
...

I have a SQL 2000 DB with collation SQL_Latin1_General_CP1_CI_AS, I am attempting to upgrade and host this in SQL 2005 Enterprise x64 bit.

When I run the installer for SQL Server 2005 I get server collation option to install as Latin1 (which...

I have a datatable object in my application (from a MS-SQL Server)
I'd like to convert it to a dictionary like key=column1 and value=column2.
But I don't really know how I can do that.

Hi!

We keep getting various Warnings in the Event log. Server running Windows 2008 Standard R2 x64. Also running MOSS 2007 and SQL 2005 Enterprise.

There are various errors, all containing a "status 1376" and "Error:...

Hi Experts,
Need your help.
The gist of this job runs every hour and if it sees a file it will convert from a flat file to excel. There are no file for SSIS to process (SSIS job stops at CheckFile Routine) .  New to SSIS and being tasked to...

Hi, I have a query which craps out with the error:

"An explicit value for the identity column in table Table_Name can only be specified when a column list is used and IDENTITY_INSERT is ON."

The table itself has a primary key and identity,...

Hi,

We currently have a Windows Server 2003 server running SQL Server 2005 and have provisioned a new server operating on Windows Server 2008 R2 64 bit running SQL Server 2008 R2.

I want to migrate all the SQL databases including logins etc...

Hi,

I ' am creating reports using crystal report included in visual studio 2005. I successfully can pass parameter programmically but every time I run the crystal report I receive this message:

The report you requested requires further...

Hi,
I have a server taken over.
On this server I can see in Backup Exec 3 different databases.
SQL Server,SQL Express and Microsoft ##SSEE

Now I have problems with the backup. When I include the db's then it is not working, when I exclude...

Hello,

The issue we are having is that any simple Select statement against a SQL Server 2005 database running on Server 2008 R2 is resulting in the following error message:.

“New transaction cannot enlist in the specified transaction...

I am recently unable to connect to connect to the MICROSOFT##SSEE SQL instance using SQL Management Studio. It houses my WSUS 3.0 databases. Upon starting the server I see this error in the event log:

Event Type:      Warning
Event Source:...

Hello,

We are new to MS SQL Server Management Studio and need to export a table to a csv formatted file. We figure there must be a wizard or some function to do this but have not found it.  Could you give us simple instructions on how to do...

I just completed installation of SQL Server 2008 R2, which seemed to be a success. But when I opened Sql Server Configuration Manager and clicked on SQL Server Services I got this error:



The remote procedure call failed [0x800706be]
...

Trying to uninstall SQL 2008. I have already 2005 on there. I do not need either at the moment. I wanted to get a full install of whichever would be best for an install of Microsoft Dynamics CRM. I have been on EE for weeks with no luck on this...

We are having an issue with our MSSQL server after a reboot that the these services won't autostart:
SQL Server (MSSQLSERVER)
SQL Server Agent (MSSQLSERVER)
SQL Server Analysis Services

Server info:
Windows Server 2003  R2 SP2
MSSQL...

A quote from http://classicasp.aspfaq.com/general/why-does-4/5-0.html:

"Why does 4 / 5 = 0?
SQL Server
 
You may be startled to see the result of this calculation in SQL Server:
 SELECT 4 / 5
 -----------  
0
 (1 row(s) affected)
...

I've got an SSIS package that I've been trying to adapt to use distributed transactions. Whenever I set the TransactionOption to "Required" in the outermost container, everything stopped working. The only way I could get any SQL steps to work...

Hi experts,

I'm trying to create a package programmatically to import data into SSIS. I'm able to do this via the wizard but, for our project we need it to be done programmatically. I've been successful in creating packages that use the Data...

Just wondering if it is possible to use the case statement to determine what to execute in a stored procedure.

The code snippet shows an example of what I'm trying to do. The select statements are the same because I haven't finished them yet,...

Hi all

In SSIS, I am trying to parse together a string (hard-coded) and an double (column) as another column, with this expression:

"Debits are " +  [debits] +", and credits are" +  [credits] +", difference is " +  [debits] - [credits]
...

I have just run my SSIS package through SQL Agent and recieved the following error.

"component "Schedules01" (426)" failed validation and returned validation status "VS_NEEDSNEWMETADATA".  End Error  Error: 2009-05-24 04:16:10.30     Code:...

How do I install 'Microsoft SQL Server Management Studio' on a Windows XP workstation? I want to have a user be able to manage SQL databases from their workstation so they dont need to use the actual server. Is there a way to pull the setup files...

Hi, I have a Stored Proc that gives me All Active Employees for any given date range. I have a function that I need to include in the Stored Proc for user security. I need to enter the user name for function and it should just return the data...

I have a SQL Server 2005 Express installed on my Intranet server that resides in my DMZ.

I have access from my LAN to my DMZ open.

I have the SQL Server configured to allow remote connections to the server.

When I attempt to access the...

I have Windows Server 2008 installation. On Intel Quad-Core processor. We had 2GB of RAM installed.

Server runs one SQL EXPRESS 2005 (for Accounting) and Windows INternal Database for Microsoft Sharepoint Services 3.0.

As application is...

I have P2V a windows server 2003 using xenconvert with Citrix Xen Server. Everything seems to working ok except for my SQL database. Below if the error message i get when i try to start the "SQL Server (EPOSERVER)" services. I found one match...

Hello all, I've spent hours troubleshooting this and I need some fresh perspective . . .

We have a relatively simple report setup in SSRS, simple matrix with columns across the top and data points going down.  The SQL query behind the report...

I have a problem with windows server 2008. I installed service pack 2 for sql server 2005.
When I boot the machine all I see is a folder opening up with icons

such as my computer, documents. I cannot see the desktop. The screen is blank...

Hi,

I was just wondering if it is possible to retain my existing SQL server 2005  and install 2008 to try it out. Any information will be very helpful.

Thanks

Am trying to convert an oracle table over to sql 2005.  In Oracle this table had a before trigger on it so that when a record was insterted it would insert the next highest value into the primary key field "person_id".  I recreated the trigger...

Hello Experts,

I have a new installation of SQL 2008, and have used the copy tool to copy over a database from SQL 2000.  Everything looks fine from the manager, however I can't determine how to change a password for a SQL user.  (Not Windows...

I am using Reporting Services 2005 and SQL Server 2000.  I placed a reportviewer control on my ASP2.0 webpage to display a report.
 
When I tried to export my report to an Excel file, I get a lot of extra columns.  I cannot sort the result...

I renamed my laptop which has a copy of SQL Server 2005 running on it. When I rebooted after renaming the machine I tried running an app which uses the ODBC connection to the SQL Server database and received the following error:

Error...

I'm getting an error which is resulting in the sql server 2005 database being inaccessible and fatal errors from .NET -

 ERROR [HY000] [Microsoft][SQL Native Client][SQL Server]Warning: Fatal error 9001 occurred at Aug 22 2007  8:43AM. Note...

Can't quite get my head around this Run-Once script, at the moment, appreciate any quick help, so I can get on with my favourite job, reviewing all the uploaded images, for approval. - LOL...

I am converting some old code .... I have a stored procedure that returns 1 row with 30 or so fields, that I need to update off a form.

To populate the form I call a SQLDATAREADER and fill each text box control.   Once data is updated, what is...

I am receiving the following error when I create a new user account using the Create User Wizard. The Create User Wizard will write all the data to the database, so the account does get created, but it always throws this error and does not show...

Hi everyone
I am trying to run the sp_oacreate master procedure from within a trigger on a sql 2005 database table. So far the only solution i have found that works is to add my database role and user roles just as they are in my current...

I have the following stored procedure:
---
create procedure uspGetRefills
@p varchar(255)
as
select * from uvwRefill
where Cast(MSRecID as varchar(255)) in (@p)
---
I want to pass in a list of parameters 'comma' delimited into the where...

Hi All,

I am needing to create a temp table using Where NOT EXISTS.  I am trying to compare data from the temp table and a permanent  table to see how much data is missing.  What am I doing wrong?

this is a generic stored procedure:

CREATE PROCEDURE [daab_UpdateCustomers]
(
      @CustomerID nchar(5),
      @CompanyName nvarchar(40),
      @ContactName nvarchar(30) = NULL,
      @ContactTitle nvarchar(30) = NULL,
      @Address nvarchar(60) = NULL,
...

We are getting this message literally millions of times each day on our Windows 2008, SQL 2005 Server.

 Event ID: 4656
Log Type: Security
Event Type: Audit Success
Category: 0
Source: Microsoft-Windows-Security-Auditing
Domain: ADMIN...

I've just installed a new vCenter server and connected 5 ESXi hosts to it.  I have migrated a bunch of virtual machines over to this new vCenter and they all seem to be working well.

The issue I am having is when I try and use the vCenter...

I installed VS2008 and the SQL Server 2008 R2 client tools a short time ago.  Unfortunately, that introduced problems with my creation of SSIS 2005 packages.  So, I thought, "No prolblem . . . I'll uninstall the 2008 stuff and be home free." ...

I'm getting this error on one of my servers in the Event Log every day.

Event ID: 107
Source: Report Server Windows
Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database.

We have a service that...

I am Using SqlcedataReader in Sql server Compact Edition 3.5, but when the application runs the Execute reader Method. It is throwing the error message as There was an error Parsing the Query. [Token Line number = 1, Token Line offset =1, Token...

My SQL Server 2005 suddenly stop working by failing the services of sql server and sql agent to start. In event viewer, i am getting the following

For SQL Server Service
------------------------------
The SQL Server (MSSQLSERVER) service...

I'm putting together a profit and loss report in SQL Server Reporting Services (SSRS). I need to display a number, e.g. 1023488.06, as 1,023.5. I've gotten as far as putting #,#,;(#,#,);- in the format property of the relevant textboxes. This...

Hi,

I installed Visual Studio 2010. Can I use it for SSRS creation?
Thanks in advance.

I am trying to run a scheduled database backup on one of our servers.  The last result section of the task is showing 0xffffffff, and my monitor tools are showing that the backup did not run.  Does anybody know what this error means, and how to...

Hi
I have an SSIS script task that builds up a variable that is a SQL server statement. I need ot be able to execute that statement in the script task.

Here is the code I have

        Dim oCnn As New Data.SqlClient.SqlConnection
       ...

I am having trouble with changing the database connection information from my development database to the production database when my reports program is run.
Here's the setup:  I develop the reports in Crystal Reports using a development...

On my 2003 Server I am getting this event ID every time I reboot. I am not able to find much information about it on google. Does anyone have any suggestions on how to fix this issue?

Here is the description from the event viewer:

Event...

Post hangs at start up. Error:Baseboard Management Controller Communication Failure.

insert proc been in place forever.... failing now with this:

OLE DB provider "SQLNCLI10" for linked server "servername" returned message "Cannot start more transactions on this session.".
Msg 50000, Level 16, State 2, Procedure...

Hi,
I am dealing with the a table to keep the services within a start and end time.

Every time i create t a service i want to assigned the end  date with maximum possible value..

is there a way to get this max value in sql server 2000
...

I have the following:

EXEC msdb.dbo.sp_send_dbmail
@recipients=N'email@address',
@body='None',
@subject ='Subject',
@body_format = 'HTML',
@profile_name = 'Profile',
@query ='set nocount on; exec dataDayStrip 657,4,7; set nocount off;',...

Is it possible to do a Linked Server to a CSV file?  If not, how do I create a View or Table that links directly to a CSV file for use by other views?

This server has already an installed version of SQL Server 2005  on windows 2003 server. The Perofomance tools and the SQL Server Profiler has not been installed. I belive the default installaiton does not install them.

Now we need to install...

I am trying to install a 3rd party app on Windows 2008 R2 DataCenter.  I get part way through the install and get an error.  I called their support and they told that it was failing because the ntwdblib.dll file is missing, as well the Named...

Hi there,

Is it possible to get the client process ID of an application that runs on SQL server?

I am attempting to connect to an SQL Server from a Pocket PC/Windows CE application through the Visual Studio 2008 Pocket PC emulator. The app consistently fails when the connection open is attempted with :
'SQL Server does not exist or access...

I currently get errors in the system log on my Windows 2008 R2 domain controller daily, such as:
Event ID: 11
Source Name: KDC
The KDC encountered duplicate names while processing a Kerberos authentication request. The duplicate name is...

I had some DTS packages that I had used the migration tool in SQL 2005 to convert into DTSX.  However I am not able to see the any of the DTSX files in my SQL 2005 Server.  So what I am trying to do is take the DTSX files and import them into a...

Hi,

How can I install SQL Server 2005 Express with INNO setup. Does anybody done this and can explain it to me? The things that I would like to accomplish are:

Check if (an older version of) SQL Server is already installed (or when the user...

Hi Experts,

I am trying to get the MSDASQL provider to work in a Stored Procedure to open a CSV file in SQL Server 2005 on a Windows Server 2008 box.

The MSDASQL is not working with error:
OLE DB provider "MSDASQL" for linked server...

Hello,

I have a simple SSIS master package ,whose main task is to run other packages through the execute package tasks. The problem Iam facing is this. It runs fine when I run the package via BIDS but I get the following errors when I set up a...

I'm not very good at the programming aspect of my job.  Can someone look at this code and tell me where I'm screwing up?

I think I'm screwing up at tmp[blahblahblah] = result(1);

I know the field i'm grabbing from is a text field..

Hi,

I ran the job and to execute a SSIS dts package in sql 2005 server, I got the following error message:

Thanks for your help!

Date            1/25/2008 4:52:00 PM
Log            Job History (Survey Returned Weekly)

Step ID            1
Server            GSBHDB3P
Job...

Hey,

I am having an issue with Team Foundation Server 2010 and what appears to be the reporting services. I only know the bare minimum about TFS and how it works with Visual Studio so I really need some help here.

From what I understand, my...

Hi there,

One of our engineers has installed SQL 2005 Express on a customers PC that uses XP SP2.

I am trying to set up a remote connection from our offices but a this time I cannot even logon to the
server using the SA account locally...

I'm trying to delete a column titled "age" from a table. I could swear I used this little query earlier and it worked, but it's not working now.

ALTER TABLE fieldreps
    DROP COLUMN age

I get this error message:
Msg 102, Level 15, State...

I need an SQL (SQL Server 2005) script that can drop one or more columns in a table if they exist.  Below is the script I have in place that is not working.

if exists ( select * from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME='dbo.TableName'...

mdf file version 655 to 612

Dear Sir / Madam,

I would like to create a Materialized Views in SQL Server, please let me know:

"      Will this view contain data as a table (kind of), periodically refresh?
"      i.e. like Oracle - Materialized Views where we can define sql and...

Hello Experts,

I'm using convert(varchar(50), @LetterReceived) to convert a bit to varchar, but it only returns 1 or 0.  I need it to return True or False.  Is there a convert or cast like function that does this?  Environment is SQL Server...

Good Day

Experts:

I am getting this error "SQL Server blocked access to procedure 'sys.sp_OACreate of component 'Ole Automation Procedures".  Using a db that I created here, I have no problems.  But when I restore data
from a customer to...

Hi experts, does anyone know what the root cause of the issue below is?   The issue occurs when my website connect to a MS SQL database on another server.  It seems to only occur when retrieving data repeatedly during a button click.  Retrieving...

Experts,

I have been trying hoplessly to connect to LDAP using my SQL Server 2005 database.
All articles I found were categorized as two code samples. See below.

My problem is that I keep getting errors no matter what I try doing. I asked...

I am trying to import a comma delimited file (.CSV) into our SQL Server 2005 Database. I am trying to use BULK INSERT. The CSV file is a FEDEX report. It has fields such as "Mon, May 1, 2008". This report is automatically generated, thus I cannot...

Hi
Having real problems getting a string held in source csv file into a datetime SQL table using SSIS Derived Column Transformation. The relevant csv column holds date information in the form:

2004-05-31 00:00:00.000

I think my data is in...

We are getting this annoying repeated errors in the errorlog

Error: 17836, Severity: 20, State: 1
Length specified in network packet payload did not match number of bytes read; the connection has been closed. Please contact the vendor of the...

I have a website that appears in multiple cities; it’s built on SQL 2005. I recently was hacked with, what I believe, was a php. script that made a SQL injection. I have not been able to figure out how to close this hole. They were able to append...

I am having issues with our WSUS Server, Whenever we go to open the MSI, we receive a connection error (corresponding Error 7032 & 7053) in the event viewer (see below).  Otherwise Error 1309 pops up every few minutes as connection is not found....

Hello fellow experts.  I figured it was time to ask a question so here it goes.  

The goal is that for each A in table #t, there will be a single returned value which is the concatenation of all values in column b.  You will see that I am...

I am trying to install Pervasive PSQL 10.10 client drivers on to a windows 2008 x64 server. The install completes with no issues, however there are no ODBC drivers installed. Also the Pervasive "Control Center" isn't installed either. I tried...

Hi there,

Can anyone confirm something, moving from oracle to sql server, and having a problem with a query, i have made a column case sensitive so the following query returns no records as the password is 'admin' not ADMIN

SELECT Username...