I have a SQL CLR Trigger, which has bizarrely (to me anyhow) requested full UI rights from CAS, SQL understandably isn€™t permitting this.
Code Snippet
The protected resources (only available with full trust) were: All
The demanded resources were: UI
I understand why SQL is failing, but what I€™d like to find out is how can I debug / isolate the offending code so I can refractor accordingly.
The namespaces I€™m utilising are as listed below; quite how or why any of these need UI requests is beyond me.
System
System.Data
System.Data.SqlClient
Microsoft.SqlServer.Server
System.Transactions
System.Text
System.Security.Permissions
System.Text
Does anyone have any experience or tips on what could be tripping me up here or how to isolate the offending call which SQL is failing?
Many thanks in advance for any help you may be able to afford me.
I have a rather intensive load on a server that has a data mapping application on the same server(I know this is a no no but I didn't have a say). It seems to be maxing the CPU. Is there a way on a dual or quad processor machine to tell SQL Server to only use one of the processors?
hello Since the past couple of months we have been seeing the tempdb grow from 5GB to 22GB about once every week. The production database is about 35GB. Since there is quite a bit of activity on the server i am finding it difficult to try to isolate what caused this sudden increase in the tempdev size. The actual data in tempdev less then 2 MB but it holds on to the 22GB till i go in and shrink it. This has led to us having serious space issues on the server. Any advise on how i would be able to trap the query that might cause this behavior would be great.
I am trying to isolate a specific record (and a value within that record) where I have selected records based on a max(date). Some records come back duplicated because there are duplicate max dates.
For example:
SELECT
O.ID, O.Date, O.Amount = Case when o.Value in ('6','7','H','I') then 1 else 2 END , O.Value
FROM Table O WHERE o.Date = (
SELECT
MAX(O2.Date) FROM Table O2 WHERE O2.ID = O.ID )
The problem is that I get some ID's with Multiple records because they have 2 different O.Values. My table looks like this:
10/12/07 A $5.00 10/12/07 B $7.00 10/10/07 C $8.00
I want to find the Max(O.Date). Since there are two, then I want to find any records with that date that have an O.Value = B, if there isn't any, then I want any with an O.Value = A, if there isn't any of those, then any records with the O.Value = C. I basically need the O.Amount depending on the hierarchy of the O.Value.
I hope that makes sense. Any help would be appreciated.
I'm trying to pull up a report of restored databases from our bug tracking software to audit and see if any of them can be taken down, and having some trouble figuring out how to pull the list of databases out of the entire request text, since they usually come in via email. Some sample data is below with the paltry beginning of a solution that I came up with.
WITH bug (BugID, BugComment) AS ( SELECT 1, 'Hello DB_001000, DB_001000, DB_001000 Blick' UNION ALL SELECT 2, 'Hi DB_001000 DB_001000 DB_001000 DB_001000 Flick' UNION ALL SELECT 3, 'Urgent DB_001000 DB_001000 Glick'
Using SQL Server 2k5 sp1, Is there a way to deny users access to a specific column in a table and deny that same column to all stored procedures and views that use that column? I have a password field in a database in which I do not want anyone to have select permissions on (except one user). I denied access in the table itself, however the views still allow for the user to select that password. I know I can go through and set this on a view by view basis, but I am looking for something a little more global.
Hi y'all, I'm facing a database data transmission problem during synchronysing. When dts fails i need a better solution instead inconsistent data. I'm looking for data comparer for sql server where i have total control of my actions. Any suggestions. THanks in advance!
Can anyone direct me to a good resource for setting up SQL2k in a failover cluster. I am trying to do this without a shared disk array, and need more info.
HI Friends One of server my job is getting fail. It will showing log speace is full but log speace is 24GB But actually my log file actual speace is 30GB How can i handile this isssue plz help me urgent Thanks MS
I have scheduled a job and the job is getting failed.I have scheduled two DTS packages in the job.But when I run the DTS Packages separately its running fine without throwing any errors.But when the Job fails I am getting the error message like "Dts package not found"
The error message which I am getting while the Job fails is
"Executed as user: TESTsqlservice. DTSRun: Loading... Error: -2147217900 (80040E14); Provider Error: 14262 (37B6) Error string: The specified DTS Package ('Name = 'DTS_MASTER'; ID.VersionID = {A35AEABF-8F05-41B5-A4C9-47F57A3208B9}.{[not specified]}') does not exist. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0. Process Exit Code 1. The step failed. "
I am trying to set up a DTS to transfer logging data from one server to another. The record may already exist at the destination causing a primary key violation. I do not want this error to cause the entire DTS to fail.
When I execute the DTS I created by right clicking and selecting "Execute Package" it shows me 2 errors. Although there are 2 errors the rows that do not have a primary key violation are successfully transfered to the destination database. Here are the 2 errors I see:
Error 1: Error at Destination for Row number 97. Errors encountered so far in this task: 97. The statement has been terminated. Violation of PRIMARY KEY constraint 'PK_event'. Cannot insert duplicate key object 'event'.
Error 2: Error at Destination for Row number 198. Errors encountered so far in this task: 198. The statement has been terminated. Violation of PRIMARY KEY constraint 'PK_eventDetail'. Cannot insert duplicate key object 'eventDetail'.
These errors make sense, there were 97 duplicate lines in the event table and 198 duplicates in the eventDetail table.
This is the behavior I want. New rows are copied to the destination database.
When I schedule the DTS as a Job in the Enterprise manager things change. When the DTS is executed as a Job (as opposed to me right clicking and selecting "Execute Package"), the job reports a failure and none of the new rows are transfered to the destination database.
Why does the DTS transfer the rows that do not violate the Primary Key constraint when I manually execute it and not when it is executed as a job?
i m facing this error when running DTS on IDENTITY(1,1) Field. how can this field increment automatically ???
Step Error Source: Microsoft Data Transformation Services (DTS) Data Pump Step Error Description:The number of failing rows exceeds the maximum specified. (Microsoft Data Transformation Services (DTS) Data Pump (80040e21): Insert error, column 14 ('s_no', DBTYPE_I4), status 10: Integrity violation; attempt to insert NULL data or data which violates constraints.) (Microsoft OLE DB Provider for SQL Server (80040e21): Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.) Step Error code: 8004206A
i tried to install sql 2005 and first time succesfully, but not able to see "Enterprise" manager even during installation i select all features.i was told unstall Visual Studio MS Express and try again. it didn't work neither. in the end i have unstalled SQL, Express SQL from Visual Studio, delete SQL from Programm Files and even clean up register still the same problem. am i doing something wrong? thank you
Hi,Is it possible to somehow set a SQL Server DTS job to automaticallydisable itself, when it encounters a fail, so that future scheduledoccurrences don't happen until the problem has been fixed?I've hunted about for this on the web, but drawn a blank unfortunately!Many thanks if anyone can help at all.
I had link my 4 of workstations to server with MySql.1 pc of my pc can run a software which can update MsSql perfectly but notothers(3 failed).I tried to add System Dsn data source for Control Panel - Odbc data source32.The pc which working fine with the software function but 3 of the rest not.My pcs running xp and win98 !Regards.Thanks.Leslie Lim
Hi,In case of failover to standby server, what is theest way to redirectclient applications to new server?1) DNS name change -- not viable due to Caching issue.IS there any alternate like Oracle's onames/LDAP for resolving namewith sql server?Can use Sever alias?Thanks
I have several packages that I download files using a sql task (I cmd shell out). I use sql task because the file names change everyday. what I want to know is how can I check to see if the file I downloaded exists either within the same task (preferred) or a task right after?? I want to fail the package instead of letting it get into the actual loading of the file where it now fails at.
I'm using SQL Reporting services 2000 SP2. I create a report and when i select pdf format in the export dropdownlist and i click on export, a popup (open/save) appears but when i click ok, i've an error message : "IE can't download Format=PDF of IP_ADRESSE".
If i do the same thing with excel type in the dropdownlist it works!
Hi, sorry again, l've a package which call the FTP tasks. In design-time, it works fine. While l put it into SQLAgent to run in schedule. It fails. The package log file said,
OnError,MAXIS-SYSOPT,NT AUTHORITYSYSTEM,FTP Raw File Motorola,{b3b941f5-ebc2-4b38-b314-87ff4827c2a8},{E93D51C5-539E-4CEE-B616-BBCFF9FA813E},4/18/2006 3:18:23 PM,4/18/2006 3:18:23 PM,-1073573489,0x,Unable to connect to FTP server using "Metrica FTP".
In SQL Server 2000, I schedule a job to run a exe. I expect the return of this result show the success or fail. However, I find the job keep running if fail. Actually, I want to see the failed status in enterprise manager.
Could you give me some suggestions how to return a fail from VB6 program to SQL Server? Maybe give me other directions to solve the problem? Thanks a lot.
More Information I run the exe by double click. if it fail, it return a prompt message box.
Hi Forum, I am having issues with hosted Sql05 server conn. Ive made the move from Oledb to Sql, so am unsure if trouble is permissions or connection related! Exception Details: System.Data.SqlClient.SqlException: Login failed for user ''. The user is not associated with a trusted SQL Server connection. <connectionStrings> <remove name="LocalSqlServer" /> <add name="ConnectionString" connectionString="Data Source=**.**.**.**;Initial Catalog=***_Database.mdf;Integrated Security=True;" /> </connectionStrings> <system.web> <roleManager enabled="true" defaultProvider="SqlRoleProvider"> <providers> <clear /> <add name="SqlRoleProvider" type="System.Web.Security.SqlRoleProvider" connectionStringName="ConnectionString" /> </providers> </roleManager> Ive tried some conn varients re security id, but its always the same error. I can use SQL Server Management Exp to login/manage database, using SQL authentication. The web app is the conn I cant open, hosting company support useles, now thats something new, cheers P
Dear experts, I've a database in sql2005 and now I want to build a same one on another machine. I've searched thru google and told that i can use backup& restore or using script. I've tested using backup/restore and it works great now i want to give a test to script. I've script the database successfully to a sql script file, however, when i run it against the new database server, the new database was not created as expected. Could anybody explain why? Thanks in advance
Login failed for user 'MERIDIANIUSR_BARODA'. .Net SqlClient Data Provider -------
what should i do?
my connectionstring is ---- conn.ConnectionString = "workstation id=BARODA;packet size=4096;integrated security=SSPI;data source=BARODAEMIS;persist security info=True;initial catalog=SMS" ---- i also create 'MERIDIANIUSR_BARODA' user.
I have 2 DTS packages that import data from an Access database that have recently started failing. They run fine manually in DTS, but not manually as a job. They get an "unspecified error." These were running fine, until we installed Outlook and started to add Outlook mail to SQL.
Originally, Administrator was the owner and that is how the jobs were run. We changed to SQLAdmin for the SQLAgent to start under, and I changed the owner of the jobs to SQLAdmin. This works for all jobs but these 2. I thought maybe SQLAdmin could not get to the Access database, but it can. I spell out the path for the database, I don't use any mappings. I recreated the jobs logged in as SQLAdmin, and they still do not work as jobs.
Any ideas are much appreciated!! Thanks in advance!! Karen
I have a package that import data from one DB to another DB. The package work fine but the scheduled job give me this error:
DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: Transfer SQL Server Objects DTSRun OnError: Transfer SQL Server Objects, Error = -2147024893 (80070003) Error string: Error source: Help file: Help context: 0 Error Detail Records: DTSRun OnFinish: Transfer SQL Server Objects DTSRun: Package execution complete. Process Exit Code 1. The step failed.
My database's log file is full. i want to backup it . First i create a backup device named aa. Than i use Enterprise to backup trasaction log. But it popup an error messagebox. The title is "Microsoft SQL-DMO(ODBC SQL state:42000) The content is "write on 'aa' failed,status=112. See the SQL error log for more details.Backup or Restore operation terminating abnormally. What's the matter ?
In the server agent properties I use the Test button and I receive the response. "Successfully started(and stopped) a mail session with this profile." Indicating that mail should work.
If I send a email notification from a scheduled job it gives me the error: NOTE: Failed to notify 'operations' via email
In the SQL Server Agent Error log I get. "[264] An attempt was made to send an email when no email session has been established"
I have a DTS package in which I would like it to fail if the table is empty. I would like to create the first task as this check (i.e. select @cnt = count(*) ... if @count = 0 then fail the task (to prevent further DTS Task processing.
Does anyone have an example or suggestion on how to set this particular Execute SQL Task to fail?
I used the wizard to create maintenance plans on my SQL 2000 servers. Part of the plan fails (checking data and index linkeage) when the job runs in off hours. It fails because it says the DB is not in single user mode. Shouldn't something in the plan take care of this. The wizard gives you no options. Or is this a bug. These jobs ran fine in SQL 7
