No announcements
Found 1129802 threads
-
0 VotesExecute multiple scripts at Once
You could use ...Answered | 8 Replies | 6698 Views | Created by Hari777 - Tuesday, April 20, 2010 9:17 AM | Last reply by Sethu Srinivasan - Tuesday, March 6, 2012 7:32 PM
-
0 Votes
Activity monitor unable to execute queries againest the server?
Hi, Please check if there are useful message in SQL error log.Answered | 5 Replies | 1353 Views | Created by ebrolove - Wednesday, April 9, 2014 8:09 PM | Last reply by tracycai - Friday, April 11, 2014 5:44 AM -
5 Votes
Many Sql scripts to execute
See my blog about the subject http://dimantdatabasesolutions.blogspot.co.il/2009/01/executing-multiple-script-file-via.html Best Regards,Uri ...Answered | 5 Replies | 1467 Views | Created by waqar100 - Saturday, February 16, 2013 4:47 PM | Last reply by Uri Dimant - Monday, February 18, 2013 10:42 AM -
1 Votes
Execution of a .sql script in SCOM
But the thing is that i have a few .sql scripts that i need to execute every 1hour or so.Answered | 2 Replies | 8675 Views | Created by sshariq88 - Wednesday, September 14, 2011 2:09 PM | Last reply by Nicholas Li - Friday, September 16, 2011 3:05 AM -
3 Votes
Need Help Execute SQL Query In Script
<html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title></title> </head> <body> ...Answered | 6 Replies | 1929 Views | Created by 1337b0x - Tuesday, December 3, 2013 3:15 PM | Last reply by Hari krishna Gutti - Monday, December 9, 2013 11:01 AM -
1 Votes
Passing Multiple Parameter in Execute SQL Task
Then you can use it through out your script.Answered | 7 Replies | 11417 Views | Created by Yuktah - Monday, May 2, 2011 11:16 AM | Last reply by Todd C - Wednesday, May 4, 2011 6:30 PM -
4 Votes
SQL Server variable declarations and the query optimizer
And demonstrates that the memory consumption for the execution context data structure increases by roughly one 8 KB page per extra varchar(8000) variable declared.Answered | 10 Replies | 3410 Views | Created by John Couch - Sunday, October 7, 2012 6:56 AM | Last reply by John Couch - Monday, October 8, 2012 7:38 PM -
1 Votes
Unable to execute query from execte sql task
can you make query like this and see?Answered | 2 Replies | 1256 Views | Created by avs sai - Thursday, September 18, 2014 10:00 AM | Last reply by Visakh16 - Thursday, September 18, 2014 10:26 AM -
0 Votes
Running multiple queries in SQL Server
yes, you can create a single script that contains all your update statements, and you can execute that , but when you will create your script make sure you satisfy all the ...Answered | 4 Replies | 2519 Views | Created by ivanovb - Monday, June 10, 2013 8:31 AM | Last reply by ameyjoe - Monday, June 10, 2013 8:44 AM -
0 Votes
Not able to execute multiple T-SQL statements in Execute SQL task.
Hi Gaurav_X, If the Execute SQL task runs a batch of SQL statements, the following rules apply to the ...Answered | 12 Replies | 5397 Views | Created by iGaurav - Tuesday, September 4, 2012 6:18 AM | Last reply by Eileen Zhao - Monday, September 10, 2012 7:19 AM -
6 Votes
Order of Execution of SQL Queries
If you are on SQL 2008 SP1 CU 5 (10.0.2746) or later, SQL 2008R2 CU1 (10.50.1702) or later, or any version of SQL 2012, then just add OPTION(RECOMPILE) to the ...Answered | 8 Replies | 105508 Views | Created by ryguy72 - Saturday, August 25, 2012 3:09 PM | Last reply by Erland Sommarskog - Thursday, July 18, 2013 8:35 PM -
1 Votes
Executing .sql scripts file from command prompt
SeeAnswered | 7 Replies | 8502 Views | Created by Krishusavalia - Tuesday, December 28, 2010 3:37 AM | Last reply by Olaf Helper - Wednesday, February 5, 2014 12:59 PM -
0 Votes
How to Declare a variable in Execute SQL task to Insert a row..?
So I have taken @columns variable to return column names with cama seperation Declare @Columns varchar(max) SET @Columns =(select ...Answered | 3 Replies | 19993 Views | Created by Roger Binny - Tuesday, July 7, 2009 8:43 PM | Last reply by Thisme - Wednesday, August 1, 2012 3:17 AM -
0 Votes
Read SQL Variables to Dynamic Query and execute
Focus on computing a static script which works with what you have now.Answered | 16 Replies | 1318 Views | Created by Jagalla - Thursday, August 25, 2016 8:50 PM | Last reply by Jagalla - Wednesday, August 31, 2016 1:24 PM -
0 Votes
error while executing the sql query
I suppose that you would not have declared a variable before running the query but would have used it in the query.Answered | 4 Replies | 5090 Views | Created by krishna143 - Friday, April 23, 2010 6:58 PM | Last reply by Challen Fu - Thursday, April 29, 2010 4:45 AM -
1 Votes
Multiple Server Query Execution ordering
The query is executed on a separate thread for each server that is connected and then the results are joined back together.Answered | 4 Replies | 6581 Views | Created by pl80 - Thursday, January 28, 2010 9:41 PM | Last reply by pl80 - Thursday, March 4, 2010 10:15 PM -
0 Votes
How to execute multiple Execute SQL Task to CSV's
You can do this in one step executing the .sql scripts using the osql exe and export it to a csv.Answered | 14 Replies | 2825 Views | Created by sk12346 - Monday, October 8, 2012 3:00 PM | Last reply by btsbee - Monday, October 8, 2012 10:48 PM -
3 Votes
SQL query with multiple subquery
Goog Day Satya, I've executed your queries correctly.Answered | 29 Replies | 8264 Views | Created by Charlie Pandacan - Thursday, January 13, 2011 8:56 AM | Last reply by Charlie Pandacan - Monday, January 17, 2011 1:55 AM -
1 Votes
Execute query for report on multiple servers
One more question, i created linked server, i see it in a linked server as server\instance, but if i try to run query like this: select * from ...Answered | 3 Replies | 3039 Views | Created by Skazimax - Wednesday, April 11, 2012 3:44 PM | Last reply by Vijey Ashok - Thursday, April 12, 2012 8:59 AM -
0 Votes
Issue with multiple update queries in 1 Execute SQL Task component
It should like below Then change your queries like below: Declare @row_count int set @row_count=?Answered | 6 Replies | 1606 Views | Created by VikasGarg - Wednesday, April 5, 2017 11:35 AM | Last reply by scott_morris-ga - Monday, April 10, 2017 5:03 PM - Items 1 to 20 of 1129802 Next ›
No announcements
