Edit Web Assistant Job
Oct 25, 2005Where do I go to modify the T-SQL statement I entered while creating a job with the web assistant wizard?
View 1 Replies
ADVERTISEMENT
Web Assistant And Triggers
Oct 17, 2001Hello everybody. I want to use Web Assistant with option "..data Change"
so Web assitant will create trigger.
The database generated from Erwin 3.5.2 and use triggers for integrity.
When I run Web assistant wizard I am getting message ".. can't create trigger becouse existing trigger created with encryption option
sp_helptext tI_prcode (my insert trigger) shows all code in the trigger
where shoild i look to disable encryption option
I found way around this problem
A.Save and delete existing trigger
B.run Web assistant trigger will created
C. Save and delete web assiatnt trigger
d. Insert code from web assitant trigger into code from original erwin
trigger and recreate it
Is any other ideas ?
Thanks a lot
Alex
Web Assistant Prob
Jan 28, 2004Hi,
i have a few web jobs, that were set up by the DBA that worked here before I did and they have just stopped running and I have no idea why.
The error I get is:
Executed as user: dbo. SQL Web Assistant: Could not establish a local connection to SQL Server. [SQLSTATE 42000] (Error 16804)
Does anyone have any experience with this?
Thanks in advance
Upgrade - Web Assistant
Dec 5, 2006We Upgraded our SQL Server 7.0 to 2005 - executed Script web.sql to create tables and procedures and now we want to execute a webtask.
But it raises the error 16820 "SQL Web Assistant faild because the state of the webtask in msdb..mswebtask is invalid"
How can i fix this
Its Urgent
thanks for your help
HANNES
Alternate To Sql Web Assistant
Jul 27, 2007I am currently with sql 2k5 and using web assistant to generate some HTML files and email the same automatically to a set of users.
these html files that are generated are processed via a JOB in sql server.
I am in process of replacing of the web assistant procedures.
Is this possible to make this with XQuery of SQL Server 2K5 and convert it into HTML files with Stored Procedure.
Is there any other possible way to do it?
Web Assistant Wizard Problem
Sep 14, 2000I used SQL Server's web assistant wizard to create a
web assistant job. In this job I chosed "When SQL
Server Data Changes" for schedule options. Late, I
don't want this job and by right click web assistant
job I deleted this job.
However, I have a stored procedure which use the same
table with the above deleted web assistant job. Normally,
the stored procedure runs only 1 minute. Today it runs
more than 5 minute and then failed. Here is the error
messages:
++++++++++++++++++++++++++++++++++++++++++++++++++ ++++
Server: Msg 16882, Level 11, State 1, Line 0
SQL Web Assistant: Web task not found. Verify the name
of the task for possible errors.
++++++++++++++++++++++++++++++++++++++++++++++++++ ++++
Please somebody can tell me how can I solve this problem
(or totally delete the above web assistant job).
Thanks.
Web Assistant And Active Directory
Jul 20, 2005HiI've created a stored procedure (see below) which accesses the ActiveDirectory and SQL server to get "real names" back. When I run thestored procedure in Query Analyzer it returns the expected results,however when I try to create a Web Assistant job based upon theprocedure I get the SQL-DMO message:Error 7410 Remote Access not allowed for Windows NT Useractivated bySETUSER.The procedure is being run (and the job created) as the account whichowns the SQL Server installation, and this account has AD adminpermissions.Any suggestions?CREATE VIEW dbo.vw_account_adASSELECT a.Name AS ad_name, dbo.Accounts.*FROM dbo.Accounts INNER JOINOPENQUERY(ADSI,'select SamAccountName, Name FROM''LDAP://w2k-bspad1/ ou=users,ou=bsp,DC=ad,DC=bl,DC=uk'' whereobjectcategory=''person'' ') a ONSUBSTRING(dbo.Accounts.Account_Name,CHARINDEX('', dbo.Accounts.Account_Name) + 1,LEN(dbo.Accounts.Account_Name) - CHARINDEX('',dbo.Accounts.Account_Name)) = a.SamAccountNameCREATE PROCEDURE [dbo].[usp_event_report] ASSET ANSI_NULLS ONSET ANSI_WARNINGS ONSELECT Code_Name, Account_Name + ' ('+ad_Name+')' as 'Account Name',Date_Occured, ResultFROM Usage_Codes, Usage, vw_account_adWHERE Usage.Code_ID = Usage_Codes.Code_IDAND Usage.Account_ID = vw_account_ad.Account_IDAND datepart(month,Date_Occured) = datepart(month,getdate())ORDER BY Code_Name, Account_Name, Date_OccuredGOChloe CrowderThe British Library
View 2 Replies View RelatedSql Server Migration Assistant Problem
Dec 24, 2007Hi,
I am converting a schema from oracle to sql server 2005 using Sql Server Migration Assistant but for the conversion of each and every table it is asking me to connect to oracle. How can i convert this schema without again and again specifying the connection?
Thanks in advance,
Aru
SQL Server Migration Assistant For Oracle
Mar 18, 2008Has anyone ever tried to use this free software to migrate an old ORACLE 8.1.7 database to SQL Server 2005? I was just wondering if there were any "gotchas" I should be aware of before hand.
Thanks,
Robert
Migration Assistant Autonumber Problems
Mar 24, 2007I am trying to migrate an Access 2003 database to SQL Server 2005 and am having various problems:
1. On one table, the migration gives the following on an autonumber field:
A2SS0023: SQL Server Migration Assistant for Access Warning Message: Default value '0' added to target column (1), followed later on by
A2SS0028: Auto-increment attribute of the column 'MSEQ' was not converted to Identity because the column has a default value.
This table has about 80,000 records.
2. If I include another table in the migration, this one with 3.4 million records (hence our need to upgrade to SQL server 2005), I am getting a timeout error, even when I try to migrate the table by itself. I have verified that all timeout options are set to zero (unlimited time).
Any suggestions would be appreciated.
-- Larry West, MCSD, MCPD, MCTS: SQL Server 2005 [so yes, I should know the answer to this, but I don't], MOUS, FLMI, ACS
SQL Server Migration Assistant For Oracle Question
Nov 24, 2006I selected my source Oracle database and my target SQL Server database. I click the convert SQL button and it takes about 20 minutes to convert everything. Then what? The Migrate Data button is greyed out. I configured the linked server as is outlined in the instructions. The "Migrate Data" button is always greyed out.
I need to get this working soon so that I can convince the management team that moving to SQL Server is the way to go.
Thanks.
The SQL Svr Migration Assistant (SSMA)..am I In The Wrong Forum?
Jun 18, 2008I have SQL 2000 and installed SQL 2005 Express. Had done some test migrations of
Access 2003 to SQL2000 using the tool for that. Upgraded that migration assistant to
SQL 2005 (my mistake) and now I have 2 instances of SQL2005 running (according to
surface area configuration) and even the server mgr for SQL2000 can see those instances..
but SSMA 2005 refuses to see them.. My migration test project is dead in the water..
Can I get a copy of SSMA for SQL2000 back?..Anybody?..
Thanks..
Pull Subscription: Publication Not Visible In Assistant
Feb 4, 2002I've a merge rep running with 4 subscribers for a while. Now I
wanted to add another subscriber and when I open the publisher
in the pull subscription assistant dialog, there are no publications
in it. (even not if i switch to "allow anonymous sub") But every-
thing seems to be alright wirh the publication itself! It even doesn't
work to select the publication in a pull subs. from an other db on the
same server! Any ideas?
Any help will be greatly appreciated!!!
Urgent: SQL Server Migration Assistant For Oracle
Sep 29, 2007i am transfering an Oracle 10g database to SQL Server 2005. i have 2 pcs one with SQL Server 2005 with SSMA For Oracle Extension 3.1 installed, also with Oracle 10g client configured to connect the Oracle database in another pc. the other pc has Oracle 10g database server installed with SSMA For Oracle 3.1. whenever i try to migrate the data there is an exception which says
"Errors: SQL Server cannot access the source table"
i dont understand why its there. i hav successfully converted the schema and loaded them in SQL Server. can anybody tell me a soltuion asap.
S ]-[ /- | ]-[ /- N
SQL Server Migration Assistant For Oracle Problem
Feb 15, 2008I can connect to my Oracle database and I can connect to my SQL Server database. But the "Convert Schema" button stays disabled. What am I doing wrong? Anyone have experience using this tool?
View 4 Replies View RelatedSQL Server Migration Assistant For Oracle Problem
Oct 6, 2006I'm trying to make the business case to move our business databases to SQL Server 2005 from Oracle 9i. The SQL Server Migration Assistant for Oracle will be absolutely necessary for this to happen. However, I am unable to launch the assistant. It tells me I have an old version of java installed - but I don't. It is a new XP machine and I downloaded and installed j2sdk-1_4_2_12-windows-i586-p.exe which did not help (I rebooted). Why does it think I have an old version and how can I get this assistant working.
Any help would be much appreciated.
Migration Assistant For Access Can't Find SQL Database?
Aug 6, 2007I've installed SQL 2005 Express Addition which created a default database using Windows Authentication -- MachineName/SQLEXPRES. I want to convert some access databases to sql server in the migration assistant, however, when I try to connect the migration assistant to the default database I can't find the database in the drop down box wizard? I'm perplexed? Please shed some light or point me to some articles that will help. Thanks.
Integration Services :: SSIS 2012 Flat File Does Not Appear In Destination Assistant
Nov 3, 2015I set up a connection file in order to move data from sql to csv files. I should be at the last step, the data flow. but:I don't see any flat file in my destination assistant.
View 23 Replies View RelatedMicrosoft SQL Server Migration Assistant For Access Fails To Migrate Data
Sep 23, 2007
I attempted to use SSMA to migrate a 2000 file format .mdb into SQL Server Express (and, as I've just purchased VS2005 Pro, into SQL Server Developer Edition).
The file is actually a backend, so nothing to migrate other than tables.
After several runs during which I received (and fixed up) some errors, the process runs smoothly with no errors or warnings, until it comes to the last step; migrating the data itself.
Data migration into 'parent' tables works fine. However, wherever I have data in a table with a foreign key relationship to any of the aforementioned 'parent' tables, it refuses to migrate it. The text of the error message will be very smiliar to the following (from the log):
[Datamigrator: Error] [464/7] [2007-09-23 14:18:54]: Exception: The INSERT statement conflicted with the FOREIGN KEY constraint "Branch$CompanyBranch". The conflict occurred in database "DPMTest", table "dbo.Company", column 'CompanyID'.
There is nothing wrong, so far as I can determine, with the relationships involved.
I can insert data into the tables using any of the following methods:
1. Directly in Access, in the source backend.
2. Using the original Access frontend application, attached to the source backend.
3. Using VB.Net forms I am developing, in the 'upsized' database.
4. Directly in the Management Studio, in the 'upsized' database.
None of these four methods complains in the least about the relationships which SSMA balks at.
I would be grateful for any ideas....thanks.
Microsoft SQL Server Migration Assistant For Access: No Convert Schema Highlighted?
Dec 6, 2006Hi all,
I downloaded the Microsoft SQL Server Migration Assistant for Access 4 weeks ago. Today, I tried this program for the first time. I added one Database with 3 Access 2003 Tables to the Access Metadata Explorer. I right clicked Databaes on the Access Metadata pane and did not see the "Convert Schema" highlighted!!!??? What is wrong with the program? How can I make it highlighted? Please help and advise.
Thanks in advance,
Scott Chang
Edit Sql
Dec 7, 2006Edski writes "Help please,
below is my sql query, when I run it, I get the right result with one problem. I get same customers with same email many times. I would only like the same customer shown one time. Checking it by email.
SELECT od.pName, od.dIndx AS dindx, od.pIndx AS pindx, od.device AS device, c.Cust_Id AS cust_id,
c.First_Name AS First_name,
c.Last_Name AS last_name, c.Email AS Email, c.Phone AS phone,c.company, h.productCode AS
product_code, DATEDIFF(dd, GETDATE(), h.expirationDate)
AS Difference, h.hotSyncId AS regcode, od.autorenewal AS autorenewal, od.installment AS
installment
FROM Orders_Detail od INNER JOIN
Hot_Sync_ID h ON od.dIndx = h.dIndx INNER JOIN
Customers c ON c.Cust_Id = h.cust_id
WHERE (od.prenewal ='False') and (od.autorenewal = 'no') and (c.newsletter <> 0) AND
(DATEDIFF(dd, GETDATE(), h.expirationDate) = '27') AND (c.company <> 'University of Alberta')
ORDER BY difference, c.Last_Name, h.productCode"
How Can I Edit An SQL Database?
Oct 9, 2004Hello,
I have been working in ASP.Net web sites with Access database.
Now I want to create a web site using an MS SQL database.
What software or softwares can I use to create and edit MS SQL databases?
I am using Windows XP Professional SP2.
Thank You,
Miguel
Pb To Edit A Recordset With VB In A DTS
Nov 24, 2001Hello,
I have some problems to edit a recordset in an ActiveX DTS using Vbscript.
Here is an example of the script :
dim varsql, varset, varconn
set varconn = CreateObject("ADODB.Connection")
set varset = CreateObject("ADODB.Recordset")
varconn.Open = "Provider=SQLOLEDB.1;Data Source=(local);Initial Catalog=Enregistrement3;user id = 'sa';password=''"
varsql = "SELECT * "
varsql = varsql & "FROM mytable "
varset.Open varsql, varconn, 3,3
msgbox "How much : " & varset.recordcount
if varset.recordcount >0 then
do while varset.eof
varset.edit
.........................
varset.update
varset.movenext
loop
end if
varset.close
varconn.close
Does someone see what is wrong ?
I allways get -1 for the varset.recordcount ! (I checked there are some records into the table).
I don't think it is a problem of user's right as it works with the same user configuration using a SQL action requery.
If I modify the open statement like this :
varset.Open varsql, varconn, 1
varset.recordcount contains the good number of records but the recordset is read noly and can't be modified...
Any Help will be very wellcome !
TIA
How To Edit A SQL DB Via MS Access?
Aug 23, 2000This is a basic, remedial question, but I've no experience whatsoever with SQL server or Access (although I'm familiar with basic DB concepts). Even so, I have inherited this project because no one else will take it (besides, I like the challenge of learning something new :-). If I understand correctly, I can use Access 2000 to create and edit DBs on my SQL 7 server, and to run queries. This is done by creating a WBEM ODBC connector (I have no idea how this is done). I'm pretty good at figuring things out on my own, but I sure would appreciate being pointed in the right direction. What I'd like to know is first of all, am I on the right track, and secondly, what do you all recommend as a good source of info on this topic (the Microsoft web site, technet, manuals?).
All info is greatly appreciated.
thanx,
-scott
Help Again Edit Parameters From MDB To ADP
Jan 31, 2006I need to convert this from Jet SqL to SQL Server. Moving out of an MDB to an ADP some of the queries I need to change over, I inherited this database and the bosses want all databases moved over from MDB to ADP.
SELECT Format$([Main Table].Date,'mmmm yyyy') AS [Date By Month], [Main Table].[Action Type], Count([Main Table].[Action Type]) AS [CountOfAction Type]
FROM [Main Table]
GROUP BY Format$([Main Table].Date,'mmmm yyyy'), [Main Table].[Action Type]
HAVING (((Format$([Main Table].[Date],'mmmm yyyy'))=[Enter the Month and the Year]));
Last Edit Time?
Jul 23, 2005How can i mark a row with its last edit time?With access it was obvious, in sqlserver?
View 1 Replies View RelatedEdit .mdf Database
Jul 23, 2005Greetings,Are there any tools freely available to modify or edit a .mdf databasefile? As far as seeing the actual tables?Regards,cd
View 6 Replies View RelatedEdit Distance
Mar 18, 2008Hi,
please, it is possible to know the edit distance used in the fuzzy lookup/grouping.
On this forum I read fuzzy lookup use 4-gram with fix size.
Does exist any document explaining how fuzzy lookup calculate the similarity? In other word, what kind of edit distance, algorithm is used by fuzzy lookup/grouping?
I hope I was enough clear with my poor english.
Thanks All
Cannot Edit Jobs
Sep 3, 2007
Two days back we have installed SP2 on SQLServer2005 Active/Active Cluster which result in failure.
Only Database Services and Analysis Services where not updated and rest of the services got updated.
After a restart , the behaviour of SQLServer is helarious.
We got into lot of problem so we opened support from Microsoft.
One of the problem i forgot to mentioed to Microsoft was on editing the Job i cannot see anything inside,all the entries where empty closing the job window and opening it again i got all my entries back but on editing i got the below mentioned Error.
Error:
Creating an instance of the COM component with CLSID {E80FE1DB-D1AA-4D6B-BA7E-040D424A925C} from the IClassFactory failed due to the following error:c001f011(Microsoft.SqlServer.ManagedDTS)
If anyone faced the same problem and got any resolution please let me know.
Anyhelp will be appriciated.
Many To Many Relationship - What's Best Way To Add/edit/delete
Aug 3, 2006I have a many to many relationship I can design the table 2 ways:1) Category table (cat_id, cat_name, active) - cat_id as PKCategoryReq (cat_id, req_name) - cat_id & req_name as PK2)CategoryReq (req_name, cat_name) - req_name & cat_name as PKIf
I design 1st way. Then when they want to add and delete from the
CategoryRequest table, they would have to add to the category table
first. Then maybe build a list of checkboxes to select from. The one's
they check insert into the CategoryRequest table.Drawback of
this is that they can't edit the list on the fly. Since it may be used
by other request (since cat_id CategoryReq is fk into Category table)If I design it the 2nd way. Then they can edit, delete, add on the fly. But there won't be a master category list.Which way is better?
How To Edit Stored Procedures ?
Apr 27, 2007I have two questions:
1) Is it possible to rename a SQL table –or- copy the content of a table into a new table ?
2) How to replace the renamed or replaced table name inside the code of Stored Procedures that references it ?
Edit SQL Identity Seed
Jan 9, 2004Because of testing and deletion, my table of user groups starts at 15 or so. Now I want to insert a group for administrators but I would like to have the groupID be 1. I tried to turn off the identity seed property and insert it manually but that didn't work.
Is there any way to do this?
Thanks, Dave
Sql MSDE Table Edit
Oct 23, 2004I have a table with data in it. Now I want to change the Data Type from int to varchar. Is there anyway to do this because I don't want to delete all the data and re-enter it. That seems to be the only way I can see to change the data type. I would appreciate some help. thanks.
View 10 Replies View Related