While running an sp_who2, I noticed a status of 'SPINLOOP'. I've never seen this before. Normally I see sleeping, RUNNABLE, and sometimes ROLLBACK.
Has anyone seen this before and/or have any idea what it means.
Sidney Ives
Database Administrator
Sentara Healthcare
Hi,
I'm using MS Report Designer 2005 and have created a report that uses a cube, with a dimension set up to convert null values to unknown (nullProcessing = UnknownMember).
When I create a parameter using the checkbox in the graphical design mode's filter pane, Report Designer automatically sets the constrained flag, eg:
STRTOMEMBER(@DimOrganisationBUSADDRSTATE, CONSTRAINED).
When running the report and selecting the 'Unkown' value from the parameter list, the error 'the restrictions imposed by the CONSTRAINED flag in the STRTOSET function were violated' occurrs.
How can I prevent the constrained flag from being used, or am I doing something wrong with converting null values to 'Unknown'?
Thanks
This is what I want to do:1. Delete all tables in database with table names that ends with anumber.2. Leave all other tables in tact.3. Table names are unknown.4. Numbers attached to table names are unknown.5. Unknown number of tables in database.For example:(Tables in database)AccountAccount1Account2BinderBinder1Binder2Binder3.......I want to delete all the tables in the database with the exceptionof Account and Binder.I know that there are no wildcards in the "Drop Table tablename"syntax. Does anyone have any suggestions on how to write this sqlstatement?Note: I am executing this statement in MS Access with the"DoCmd.RunSQL sql_statement" command.Thanks for any help!
View 2 Replies View RelatedHello,
I need to perform an update to one of my columns in my gridView. Is it possible to pass in the "column name" during runtime as a parameter to a stored procedure. I tried doing that but it doesn't seem to work? I might be doing something wrong of course.
Can anyone give me some advice on how to do this?
I'm sure that the try part of following code are all executedand the session("isLogin") has set to Truebut it always catch a exceptionand redirect to error1.aspx can't figure it out 1 Try
2 mySqlCon = New SqlConnection(strMySqlCon)
3 mySqlCmd = New SqlCommand(strMySqlCmd, mySqlCon)
4
5 mySqlCon.Open()
6 myDataReader = mySqlCmd.ExecuteReader()
7
8 If myDataReader.Read() = True Then
9
10
11 webPwdMd5 = System.Web.Security.FormsAuthentication. _
12 HashPasswordForStoringInConfigFile(Me.TextBox1.Text, "MD5")
13
14 If webPwdMd5 = myDataReader.Item("password") Then
15 Session("isLogin") = True
16 'Me.TextBox1.Text = "ppp"
17 Response.Redirect("main.aspx")
18 Else
19 Session("islogin") = False
20 Me.Label1.Visible = True
21 End If
22 Else
23 Session("isLogin") = False
24 Me.Label1.Visible = True
25 End If
26
27 mySqlCon.Close()
28
29 Catch Myexception As Exception
30 Session("isLogin") = False
31 Response.Redirect("error1.aspx")
32
33 Finally
34
35 End Try
The Microsoft SQL Server icon is showing on my task bar but with a white (blank) circle "stamped" over the bottom right of the icon.
To me it seems that the implication is that somehow the server is not being recognized as (local)etSDK.
Resting the mouse arrow on the Server icon displays: unknown - \ - MSSQLServer
Needless to say something is quite wrong and I cannot open nor create ANY DATA while on WebMatrix.
If I right-click on the server icon and select "Start" I get the following error: "Invalid handle" which apparently is error number 6.
Previously, after many try-outs I managed to at least put the server icon on the task bar by making use of a setup.ini file that reads as shown below (and then typing from the MSDE sub directory while in MSDOS "setup.exe").
[Options]
INSTANCENAME=CADComputing
SECURITYMODE=SQL
SAPWD=myPassword539
Is there a way out of this mess?????
Hello!!!
I have installed sql 7.0 with sp1. when I check the files I saw to more file extra i.e. distmdl.mdf and distmdl.ldf along with system and pubs and northwind database files.
Can any one tell me what are these(distmdl.mdf and distmdl.ldf ) files.
Thank you!!!!!
Dindu
protected void Button4_Click(object sender, EventArgs e)
{
string selectedItem = DropDownList1.SelectedItem.Text;
if (selectedItem == "zezo")
{
string connectionString2 = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
SqlConnection connection2 = new SqlConnection(connectionString2);
connection2.Open();
SqlCommand command2 = new SqlCommand("finde", connection2);
command2.CommandType = CommandType.StoredProcedure;
command2.Parameters.Add("@columen_name", SqlDbType.NVarChar).Value = "taher";
command2.ExecuteNonQuery();
}
and this is the stored procedure
ALTER PROCEDURE dbo.finde @columen_name nvarchar(50)
/*
(
@parameter1 int = 5,
@parameter2 datatype OUTPUT
)
*/
AS
declare
@maxcount int,@sql varchar(8000)
set @maxcount=(select max(taher)+1 from counter)
set @sql='insert into counter (' + @columen_name +')
values ( @maxcount )'
exec (@sql)
************************
and this is the error
Server Error in '/NTSOLUTIONS' Application.
--------------------------------------------------------------------------------
Must declare the scalar variable "@maxcount".
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Must declare the scalar variable "@maxcount".
Source Error:
*********************************************
so i can not find where is the exact point
zezo
I'm running into a situation that has me adding a value of "Unknown" toa reference table. I am being pulled between two trains of thought, andwas curious to get other's input on in. I give an example below.1-) Adding "Unknown" to a reference table is bad. Doing so effectivelychanges the Nullability option of every FK that references the table toa NULLable FK relation.2-) Simply adding a "Not Known/Undetermined" value to the referencetable greatly simplifies things. No schema changes are required, andprograms that use the reference table to populate their drop-downs willautomatically see the new value.Perhaps both approaches are good, but it would all depend of thecontext, the criticality of other FKs that reference the table, how/whenthe data is being used?==============================================EXAMPLE==============================================Assume two tables. Employee & EyeColor, as described below.+===================================+|Employee |+----------------+------------------+|EmployeeId(PK) | EyeColorId (FK) ||NOT NULL | NOT NULL |+----------------+------------------+|marc | 1 ||dan | 2 ||sonya | 1 |+================+==================++================================================= ===+|EyeColor |+---------------+------------------+-----------------+|EyeColorId(PK) | EnglishName(AK1) | FrenchName(AK2) ||NOT NULL | NOT NULL | NOT NULL |+---------------+------------------+-----------------+| 1 | Brown | Brun || 2 | Bloodshot | Rouge || 3 | Blue | Bleue |+===============+==================+============== ===+And let's say that an automated process is being built to import EyeColors from central database. In this process EyeColor may no longer beavailable.With solution #1, new (or existing) data is changed as follows:+----------------+------------------+|EmployeeId(PK) | EyeColorId (FK) ||NOT NULL | NULL |+----------------+------------------+|marc | 1 ||dan | 2 ||sonya | 1 ||newemp | NULL |+================+==================++================================================= ===+|EyeColor |+---------------+------------------+-----------------+|EyeColorId(PK) | EnglishName(AK1) | FrenchName(AK2) ||NOT NULL | NOT NULL | NOT NULL |+---------------+------------------+-----------------+| 1 | Brown | Brun || 2 | Bloodshot | Rouge || 3 | Blue | Bleue |+===============+==================+============== ===+With solution #2, new (or existing) data is changed as follows:+----------------+------------------+|EmployeeId(PK) | EyeColorId (FK) ||NOT NULL | NULL |+----------------+------------------+|marc | 1 ||dan | 2 ||sonya | 1 ||newemp | 0 |+================+==================++================================================= ===+|EyeColor |+---------------+------------------+-----------------+|EyeColorId(PK) | EnglishName(AK1) | FrenchName(AK2) ||NOT NULL | NOT NULL | NOT NULL |+---------------+------------------+-----------------+| 0 | Unknown | Inconnu || 1 | Brown | Brun || 2 | Bloodshot | Rouge || 3 | Blue | Bleue |+===============+==================+============== ===+*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
View 3 Replies View Relatedwhy in a adomd connection these items are unknown
AdomdConnection,
connection,
MiningService,
and in the amo connection these itmes are unknown:
server.Connect,
MiningStructure,
miningmodel,
MiningModelAlgorithms
When I try to run my package from SQL Server Agent I get the following errormessage:
Message
Executed as user: NT AUTHORITYNETWORK SERVICE. The return value was unknown. The process exit code was -532459699. The step failed.
It has nothing to do with security in any way: The package actually succeeds!! (no onErrorEvent is thrown, no Error or whatsoever is logged). The only logging I get is this:
#Fields: event,computer,operator,source,sourceid,executionid,starttime,endtime,datacode,databytes,message
PackageStart,KMAUSQL01SRV,NT AUTHORITYNETWORK SERVICE,Test,{3790FAE9-8300-4374-B2B7-6A630A508ED9},{E15D1815-1123-42D5-9D32-75B0237660A3},23.08.2006 17:18:02,23.08.2006 17:18:02,0,0x,Beginning of package execution.
PackageEnd,KMAUSQL01SRV,NT AUTHORITYNETWORK SERVICE,Test,{3790FAE9-8300-4374-B2B7-6A630A508ED9},{E15D1815-1123-42D5-9D32-75B0237660A3},23.08.2006 17:18:24,23.08.2006 17:18:24,0,0x,End of package execution.
PackageStart -> PackageEnd .... And in Fact the package DOES exactly do what it should! Just that it throws this error anyway!
What can I do to even trace down where the error occurs?? Not to mention fix it?
Hi Experts,
I am extracting data from SQL Server 2005 to flat file destination. I am using SQL Command to specify the data selection query. One of my query uses Replicate function to derive a column value. When I execute this package it fails with the error "Data conversion failed. The data conversion for column "value" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page".
The reason for the problem is that, it is taking the InputColumnWidth of the flat file destination as 8000 and I specified the OutputColumnWidth as 4.
If I change the OutputColumnWidth to 8000, it is working without any error but resulting in the column width of 8000.
I tried using DerivedColumn Transformation's Type cast and DataConversion Transformation but still I am getting the same error in the respective Transformation components.
Can anyone suggest how to solve this issue.
Hello All!!!
I have a 1.1 asp.net applications that has been in production for a little over a year. It is remoted from a webserver --> application server --> that access data server. I am using win2003 servers and sql 2000. Recently, the application has been having an issue retrieving and storing documents to the sql server. When diagnosing the problem I have ran communication testing to make sure the servers are communicating as they should, I have ran the stored procedure to test for retrieval times and/or failure. So far everything has checked out. While researching the issue, I ran across information that suggested changing from the SQLClient provider to the OLEDB provider. All the changes I have tried appear to have no affect.
I will mention that this does seem to occur only when retrieving larger files(probably a communication issue which I have my communications staff looking into). Has anyone experienced this issue and maybe know of any possible solutions?
Thanks in advance
With this algorithm you can sum up an unkown number of records, so that an aggregation matches a fixed value.
If there is not an exakt match available, the algorithm returns the nearest possible value!-- Initialize the search parameter
DECLARE@WantedValue INT
SET@WantedValue = 349
-- Stage the source data
DECLARE@Data TABLE
(
RecID INT IDENTITY(1, 1) PRIMARY KEY CLUSTERED,
MaxItems INT,
CurrentItems INT DEFAULT 0,
FaceValue INT,
BestUnder INT DEFAULT 0,
BestOver INT DEFAULT 1
)
-- Aggregate the source data
INSERT@Data
(
MaxItems,
FaceValue
)
SELECTCOUNT(*),
Qty
FROM(
SELECT 899 AS Qty UNION ALL
SELECT 100 UNION ALL
SELECT 95 UNION ALL
SELECT 50 UNION ALL
SELECT 55 UNION ALL
SELECT 40 UNION ALL
SELECT 5 UNION ALL
SELECT 100 UNION ALL
SELECT 100 UNION ALL
SELECT 100 UNION ALL
SELECT 100 UNION ALL
SELECT 100 UNION ALL
SELECT 50 UNION ALL
SELECT 250 UNION ALL
SELECT 100 UNION ALL
SELECT 100 UNION ALL
SELECT 100 UNION ALL
SELECT 100 UNION ALL
SELECT 100 UNION ALL
SELECT 100 UNION ALL
SELECT 100 UNION ALL
SELECT 100 UNION ALL
SELECT 100 UNION ALL
SELECT 90 UNION ALL
SELECT 100 UNION ALL
SELECT 100 UNION ALL
SELECT 100 UNION ALL
SELECT 100 UNION ALL
SELECT 100 UNION ALL
SELECT 100 UNION ALL
SELECT 50 UNION ALL
SELECT 350 UNION ALL
SELECT 450 UNION ALL
SELECT 450 UNION ALL
SELECT 100 UNION ALL
SELECT 100 UNION ALL
SELECT 50 UNION ALL
SELECT 50 UNION ALL
SELECT 50 UNION ALL
SELECT 1 UNION ALL
SELECT 10 UNION ALL
SELECT 1
) AS d
GROUP BYQty
ORDER BYQty DESC
-- Declare some control variables
DECLARE@CurrentSum INT,
@BestUnder INT,
@BestOver INT,
@RecID INT
-- If productsum is less than or equal to the wanted sum, select all items!
IF (SELECT SUM(MaxItems * FaceValue) FROM @Data) <= @WantedValue
BEGIN
SELECTMaxItems AS Items,
FaceValue
FROM@Data
RETURN
END
-- Delete all unworkable FaceValues
DELETE
FROM@Data
WHEREFaceValue > (SELECT MIN(FaceValue) FROM @Data WHERE FaceValue >= @WantedValue)
-- Update MaxItems to a proper value
UPDATE@Data
SETMaxItems =CASE
WHEN 1 + (@WantedValue - 1) / FaceValue < MaxItems THEN 1 + (@WantedValue - 1) / FaceValue
ELSE MaxItems
END
-- Update BestOver to a proper value
UPDATE@Data
SETBestOver = MaxItems
-- Initialize the control mechanism
SELECT@RecID = MIN(RecID),
@BestUnder = 0,
@BestOver = SUM(BestOver * FaceValue)
FROM@Data
-- Do the loop!
WHILE @RecID IS NOT NULL
BEGIN
-- Reset all "bits" not incremented
UPDATE@Data
SETCurrentItems = 0
WHERERecID < @RecID
-- Increment the current "bit"
UPDATE@Data
SETCurrentItems = CurrentItems + 1
WHERERecID = @RecID
-- Get the current sum
SELECT@CurrentSum = SUM(CurrentItems * FaceValue)
FROM@Data
WHERECurrentItems > 0
-- Stop here if the current sum is equal to the sum we want
IF @CurrentSum = @WantedValue
BREAK
ELSE
-- Update the current BestUnder if previous BestUnder is less
IF @CurrentSum > @BestUnder AND @CurrentSum < @WantedValue
BEGIN
UPDATE@Data
SETBestUnder = CurrentItems
SET@BestUnder = @CurrentSum
END
ELSE
-- Update the current BestOver if previous BestOver is more
IF @CurrentSum > @WantedValue AND @CurrentSum < @BestOver
BEGIN
UPDATE@Data
SETBestOver = CurrentItems
SET@BestOver = @CurrentSum
END
-- Find the next proper "bit" to increment
SELECT@RecID = MIN(RecID)
FROM@Data
WHERECurrentItems < MaxItems
END
-- Now we have to investigate which type of sum to return
IF @RecID IS NULL
IF @WantedValue - @BestUnder < @BestOver - @WantedValue
-- If BestUnder is closer to the sum we want, choose that
SELECTBestUnder AS Items,
FaceValue
FROM@Data
WHEREBestUnder > 0
ELSE
-- If BestOver is closer to the sum we want, choose that
SELECTBestOver AS Items,
FaceValue
FROM@Data
WHEREBestOver > 0
ELSE
-- We have an exact match
SELECTCurrentItems AS Items,
FaceValue
FROM@Data
WHERECurrentItems > 0With references to
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=73540
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=73610
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=78015
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=79505
Peter Larsson
Helsingborg, Sweden
Hi all,I have the below user-defined function on mssql 2000 and I can't workout why i'm getting the following error:-----Server: Msg 156, Level 15, State 1, ProcedurefnCalculateOutworkerPaymentForBox, Line 15Incorrect syntax near the keyword 'IF'.Server: Msg 170, Level 15, State 1, ProcedurefnCalculateOutworkerPaymentForBox, Line 23Line 23: Incorrect syntax near ')'.----------CREATE FUNCTION fnCalculateOutworkerPaymentForBox(@boxid int)RETURNS moneyASBEGINRETURN (/* if the box is a paperback */IF (SELECT COUNT(BoxID) AS NoOfBoxes FROM OutworkerBoxes WHERE BoxID= @boxid AND BoxCode LIKE '%PAPER%') > 1/* If the books are paperback, charge 15p each and add on 30p for adescription book to make 45p */SELECT ((endref - StartRef) * 0.15) + (NoOfDescriptionBooks * 0.30)FROM OutworkerBoxes WHERE BoxID = @boxidELSE/* If the books are normal, charge 25p each and add 20p on fordescription books to make 45p */SELECT ((endref - StartRef) * 0.25) + (NoOfDescriptionBooks * 0.20)FROM OutworkerBoxes WHERE BoxID = @boxid)END-----Below is the sql for the table it works with:-----CREATE TABLE [OutworkerBoxes] ([BoxID] [int] IDENTITY (1, 1) NOT NULL ,[OutworkerID] [int] NOT NULL ,[ImportedBy] [int] NULL ,[StartRef] [int] NOT NULL ,[endref] [int] NOT NULL ,[DateIssued] [datetime] NOT NULL ,[BoxCode] [nvarchar] (50) COLLATE Latin1_General_CI_AS NOT NULL ,[DealerID] [int] NULL ,[StatusID] [int] NOT NULL ,[IssuedBy] [int] NOT NULL ,[BoxNotes] [nvarchar] (200) COLLATE Latin1_General_CI_AS NULL ,[DateImported] [datetime] NULL ,[NoOfDescriptionBooks] [int] NOT NULL CONSTRAINT[DF_OutworkerBoxes_NoOfDescriptionBooks] DEFAULT (0),CONSTRAINT [PK_OutworkerBoxes] PRIMARY KEY CLUSTERED([BoxID]) WITH FILLFACTOR = 90 ON [PRIMARY]) ON [PRIMARY]GO-----If anyone can advise me i'd be most grateful.Thanx in advanceJames
View 2 Replies View RelatedI have a client using SQL 2k, SP2 (due application requirements, SP3 is notan option - the application vendor will not specify why). We are receiving:[Microsoft][ODBC SQL Server Driver]Unknown token received from SQL ServerConnection BrokenThere doesn't appear to be any rhyme or reason as to why this is happening.And...it shows it's ugly head at random places during execution. Has anyoneexperienced this also, or have any ideas on what to look for? I have seennumerous suggestions stating to upgrade from MDAC 2.6 to 2.7. At thispoint, I'm not sure if thats an option based on the vendors application(which by the way they no longer support!).Any ideas will be greatly appreciated.Greg
View 1 Replies View RelatedI don€™t know if this is the case but I need some help. We have itanium server with Microsoft SQL Server 2005 - 9.00.3054.00 (Intel IA-64) Mar 23 2007 18:42:19 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2).
We has had lot of problem with that the sqlserver.exe process hangs 100% cpu. It€™s totally non responsive I€™m not even able to contact the server with DAC. The general solution has been just kill the process. Not nice.
https://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=440746&SiteID=17
The log is full of those
Date,Source,Severity,Message
08/16/2007 09:00:38,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
08/16/2007 08:55:17,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
08/15/2007 13:06:09,spid4s,Unknown,LazyWriter: warning<c/> no free buffers found.
08/14/2007 10:07:08,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
08/09/2007 11:07:29,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
08/06/2007 09:41:13,spid2s,Unknown,LazyWriter: warning<c/> no free buffers found.
08/06/2007 09:14:50,spid2s,Unknown,LazyWriter: warning<c/> no free buffers found.
08/06/2007 08:54:38,spid2s,Unknown,LazyWriter: warning<c/> no free buffers found.
08/06/2007 08:24:59,spid2s,Unknown,LazyWriter: warning<c/> no free buffers found.
08/03/2007 11:09:54,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
08/01/2007 12:30:56,spid2s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/31/2007 10:16:45,spid2s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/30/2007 10:44:22,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/24/2007 01:03:36,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/23/2007 01:02:33,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/16/2007 12:27:52,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/16/2007 12:25:12,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/16/2007 11:54:07,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/16/2007 11:44:16,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/14/2007 01:04:15,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/12/2007 06:18:51,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/12/2007 06:06:49,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/10/2007 13:20:08,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/10/2007 13:10:43,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/09/2007 10:36:27,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/09/2007 10:28:46,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/06/2007 10:12:20,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/06/2007 10:09:39,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/06/2007 10:06:19,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/06/2007 10:01:28,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/06/2007 01:17:08,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/06/2007 01:13:47,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/04/2007 10:41:06,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/03/2007 10:24:24,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/03/2007 01:22:44,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
06/28/2007 01:03:03,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
LazyWriter: warning, no free buffers found.
We used to solution to set a fixed as told in the post above and after that the problem went away. At least for the last 4 days.
Is this LazyWriter not fixed in SP2 for itanium or what?
I recently tried Re-Installing SQL Server 2005 and setup fails with the following error message. I found a forum that instructed me to make sure that the Distributed Transaction Corrdinator Service is started and that the NT AUTHORITYNetworkService is set under the Log on as tab. I verified both of those settings in my services snap-in under the management console. Looks like setup is failing during this section: Integration Services - Configuring Components...
------------------------------
Microsoft SQL Server 2005 Setup
Failed to install and configure assemblies C:Program FilesMicrosoft SQL Server90DTSTasksMicrosoft.SqlServer.MSMQTask.dll in the COM+ catalog. Error: -2146233087
Error message: Unknown error 0x80131501
Error description: You must have administrative credentials to perform this task. Contact your system administrator for assistance.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=29549&EvtType=sqlca%5csqlassembly.cpp%40Do_sqlAssemblyRegSvcs%40Do_sqlAssemblyRegSvcs%40x80131501
An unknown error (-50) occurred.
So I can not recieve my email.
Running Entourage Student Ed.2004, Mac OS 10.5!
does any know what this means:
View 3 Replies View RelatedI'm on SQL Server 2005 SP2.
I have the old age question of how to process a string parameter that is passed to a Stored Procedure that has an unknown number values. The example below has 5 values but it could be anywhere between 1 and 20.
I basically need to extract each value to Insert these values into the appropriate tables.
In the SQL 2000 days I use to do this with some T-SQL code that determines where the comma is and then I get the value and so on.....
I have read somewherethat this can be achieved using the XML Data Type.
Can someone show me that or atleast get me started on how to achiev this?
DECLARE @Range VARCHAR(200)
SET @Range = '10, 4, 8, 6, 22'
I have a package which imports text files in a directory. The problem I am having is that the text files have differing numbers of source columns. Can anyone example me some script which handled differing numbers of source columns for a dts package...
View 1 Replies View RelatedHi All,
I was testing SQL Mail and I kept getting Unknown Recipient error regardless of what type of user names I tried to put in, I'd appreciate it if any of you could help.
Server: NT 4.0 Server (SP4)
SQL Server: 6.5 (SP4)
Mail Client: Exchange (5.0)
Since my company doesn't have a designated mailbox for SQL Server, I set it up to use my personal mailbox and profile. I was able to get SQL Mail up and running but couldn't not figure out a correct user name to pass to xp_sendmail.
The usual format of our e-mail addresses is <last name><first name>@xxx.com so I tried '<last name><first name>', '<last name>, <first name>' (the same format shown in the Address Book)...etc. but none of those worked.
Am I missing something?
Hi there I dunno if this is the correct place to ask this.I got this database that is part of application, I need to convert/migrate it to any other current database like SQL server, the problem is that I dunno the database type, with his current application I know it got stored names and address, from the application I can only export 9999 records at the same time.The database is a 300mb DAT file.I have never done anything like this before so Any help or suggestions would be apreciatte, ty.Database opened with Index Data Suite:http://b.imagehost.org/0096/index_data_suite.jpgDatabase opened with Hex Editor:http://b.imagehost.org/0096/hex_pic.jpg
View 11 Replies View RelatedI want to write a DTS that will import a file every day. The problem is that the files is not named the same thing every day. There is a naming convention (SOMMDDYY.TRN) that it will follow. I want to import this file (which is a fixed width file) each day to a table (The table will be empty each day).
After it is imported, I want to look at the NAME of the file, and pull out the date portion of it. So, if the file is called SO122603.TRN, i want to pull out 122603, and then update my table with that date for every record. So when I am done, I will have a table that represents the file I imported, with one added column. This added column would be a Date/Time that has the date that was in the filename. How do I do this???
If a procedure is known but all parameters are not known, can I handle this using CommandBehavior.RetrieveParameters.
If yes, do I need to incur an extra round trip to server.
Keshka writes "I'm using function fnParseString form http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=76033 in some of my sp.
it's very helpfull, but my question is if there is a way to split variable into columns if I don't know how many columns I'll have? It could be 1 or 2 or 3 and etc.
Thanks"
Hi all,While debugging some old code from someone, I came across this storedprocedure:SELECT dbo.TBL_COORD.COORD_ID AS ID, dbo.TBL_COORD.LATITUDE AS Latitude,dbo.TBL_COORD.LONGITUDE AS Longitude,dbo.TBL_COORD.NORTHING AS Northing,dbo.TBL_COORD.EASTING AS Easting, dbo.refDROP_VALUES.Drop_Value AS [GeometryType],refDROP_VALUES_1.Drop_Value AS [GPS Datum],refDROP_VALUES_2.Drop_Value AS [GPS Used]FROM dbo.TBL_COORD INNER JOINdbo.refDROP_VALUES ON dbo.TBL_COORD.GEOMETRYTYPE_ID =dbo.refDROP_VALUES.ID INNER JOINdbo.refDROP_VALUES refDROP_VALUES_1 ONdbo.TBL_COORD.GPS_DATUM = refDROP_VALUES_1.ID INNER JOINdbo.refDROP_VALUES refDROP_VALUES_2 ONdbo.TBL_COORD.GPS_USED = refDROP_VALUES_2.IDWHERE<some conditions here>This query seems to work fine, however I cannot see ANY source to the tablesrefDROP_VALUES_1, and refDROP_VALUES_2. There are no views/tables/storedprocedures of any kind with these names in the databse, so I'm at a loss asto where they're coming from. Note that there IS a table refDROP_VALUES, andthe fields that refDROP_VALUES_1 and refDROP_VALUES_2 reference ARE fieldsin the table refDROP_VALUES. I can view the results from running the query.Whats going on here? Does MS SQL create these tables?Jack.
View 4 Replies View RelatedI created dropped all indexes in a database and run in one database instead of actual databse. How to recreate again dropped indexes ...
View 4 Replies View RelatedI work with a group that develops Access Databases in a LAN environment. We have an issue with others linking into our databases but not letting us know. Does anyone know of a way to determine what other databases have linked into a database to use its data? When we try to modify databases, this becomes an issue since we can not save mods if the file is in use.
Hi All,
I am new to sql server 2005.
I tried to connect to reporting services configuration manager.
it gives an error
An Unknown error has occured in WMI provider.
error code 80040219.
so please help me out regarding this issue.
Greetings:
I am trying to load data in SQL Server 2005 using bcp. I get the following message from bcp:
SQLState = HY000, NativeError = 0
Error = [Microsoft][SQL Native Client]Attempt to read unknown version of BCP for
mat file
The format file starts as follows:
9.0
206
1,SQLCHAR,0,5," ",1,ZIPCODE
2,SQLCHAR,0,4," ",2,ZIP_4
...
Does the first line appear correct ? Any suggestions on what to change would be appreiciated.
Thanks.
alan
I have a SQL Server 2005 server with no maintenance plans configured and no SQL agent jobs. The SQL logs are indicating that every night around midnight the databases I have created are all taken offline and backed up. How do I determine what is triggering these backups?
View 1 Replies View Related