Topic profile page for SQL script.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: SQL script.
Topic "Sql script" was discussed 1,769 times on 180 sites in last 3 months
Started 3 days, 23 hours ago (2009-11-06 15:42:00)
by Jimbo
Hi, SQL 2005 Enterprise Edition (SP2) I'm having trouble running a SQL script generated via the SQL 2005 Profiler. I've set up a very simple proifle template to look for 'Crystal Report' SQL that runs for over 2 seconds in the mill - the only two filters I have on the template are 'Application name' and 'Duration'. When I run it in the Profile GUI, all is fine, and I receive the expect output....
Started 5 days, 4 hours ago (2009-11-05 10:41:00)
by DBFinder
Hi Guys, How can I use -m switch in middle of my SQL script. I used this while running this script as Quote: db2 -mtvf DelRows.SQL But I need a few rows of long script to show me how many rows were affected. Code: : : ----need to switch m ON insert into trans_history select * from trans where trans_id < current date - 21 days; ...
Started 5 days, 11 hours ago (2009-11-05 03:03:00)
by user11126697
I have migrated from Informix to Oracle 10g using OMWB. I now want to drop all the objects that were created by OMWB using the drop.sql script that was created by OMWB. I am running drop.sql via the command window in pl/sql developer but get many error messages similar to the one as follows: ORA-01927: Cannot revoke privileges you did not grant...
Started 6 days, 14 hours ago (2009-11-04 00:00:00)
by Dame1701
Hi Guys, I have created in Wise Installation studio 7.0 an MSI installer which deploys a database to either C:\Program Files\Root6\Database (on 32 bit system) or C:\Program Files (x86)\Root6\Database (on 64bit system). The installer then runs an SQL Server script to attach the database: USE master; GO if (SELECT SERVERPROPERTY ('Edition')) = 'Express Edition (64-bit)' BEGIN...
Started 1 week, 1 day ago (2009-11-02 05:57:00)
by shabar
Hi CREATE TABLE pivot_table AS SELECT * FROM (SELECT EXTRACT(YEAR FROM hiredate) year, job, sal FROM emp) PIVOT (SUM(sal) FOR job IN ( 'SALESMAN' AS Sales, 'CLERK' AS Clarical)); In above script I get following error [1]: (Error): ORA-00933: SQL command not properly ended What could be the reason rgds shabar...
Started 1 week, 2 days ago (2009-11-01 14:26:00)
by whk
I'm not a SQL guru but know how to run a script from the admin panel for the database. Since there is no admin screen to set default preferences, can someone please post SQL scripts I can run as admin that will do the following? 1. Set the answer to "Yes" for all users "Do you want to be notified via email when you receive a private message?" 2. Set the answer to "Yes" for all users "Accept ...
Started 1 week, 3 days ago (2009-10-30 18:11:00)
by Joe K.
I numerous SQL Server 2005 database instances. Please help me with a t-sql script with login names that have following sysadmin,security, db_ddladmin,and db_accessadmin permissions within SQL Server 2005 database instance.
Started 1 week, 4 days ago (2009-10-30 10:10:00)
by Joe K.
I numerous SQL Server 2005 database instances. Please help me with a t-sql script with login names that have following sysadmin,security, db_ddladmin,and db_accessadmin permissions within SQL Server 2005 database instance.
Hey Everyone, I’m after a Web Designer, PHP and SQL programmer I’m after someone that may have worked on a GPT (Get Paid To) and knows and understands how to integration a CPA system into the website I’m after a custom script, I have written up a brief development plan. I will need the script developing within 15-30 days and I have set a budget for this project at $1,000 payable via ...
Started 4 days, 8 hours ago (2009-11-06 06:43:00)
by whk
Thanks Rick. I just updated the board rules to let people know that as a condition of signing up on the forum, they have to accept messages from the administrator.
Started 1 day, 20 hours ago (2009-11-08 18:49:00)
by Jimbo
Erland, Thank you. I have created scripted profiler SQL myself without using the Profiler to create it for me, so I will have a look at the SQL created. Thanks once again. James.
Started 5 days, 6 hours ago (2009-11-05 08:27:00)
by user11126697
You may have a point. However, I have cut all the statements ( excluding all the revoke statements ) from the drop.sql script and pasted them into a command window in pl/sql developer and executed them. This includes all the drop user statements generated by OMWB in the drop.sql script - these come after the revoke statements which effectively completes ...
Started 1 week ago (2009-11-02 19:25:00)
by Russell Fields
Joe, You have both server and database level rights listed in your title. For server roles such as sysadmin: EXEC sp_helpsrvrolemember For database roles such as db_ddladmin: EXEC sp_helprolemember For 2005 server roles, the query is almost the same as that Uri showed you for databases. The only difference is the name of the views. Every place 'database' appeared, use 'server' instead. ...
Started 6 days, 7 hours ago (2009-11-04 07:02:00)
by saktiranjan
How do we avoid truncation of data generated from osql to file? If the output data is more than 8K then it truncates in the outout file. And also. I have observed that the data in the file contains fixed length data.