i am started sql server profiler, but every 2 or 3 second "exec sp_reset_connection" stored procedure is executing.
so i cannot see my trace of query.
how can i stop tihs.
View Complete Post
Is there a function I can use in the precedence constraint editor to check if a Exec SQL task populated an ADO recordset object?
Basically I have a select a,b,c from metadata_table where key = param and enabled = 1 and the output gets saved as an recordset object
I want the constraint to check that the object was populated before continuing and error out if not (the package should never execute with 0 rows being returned)
i've tried using
!isnull(User::ListOfFiles) and Len(User::ListOfFiles)>0 but both return true even when 0 rows are returned
I'd rather not add a @@rowcount output parameter to the Exec SQL task
Does the object have any methods I can use in the expression bit of the constraint editor that'll check if it has any rows? Or are there any Count-like functions that'll work on it? I'm not much of a .net coder so can't think of anything else
edit: nvm I just realised I need to use a script task to set the error message anyway so I can load the object there and do a Rows.Count
I had a custom confirm box Using Jquery....In that It crates two buttons Yes and No.
I need to execute my code in Yes click.....how?????
I cannot seem to work out how to put it together I get all sorts of errors
I would like to create a single bat file that execute 3 bat files and runs 10 sql scripts.
Any examples? help thanks a lot
I'm working on converting a datbase currently in SQL 2000 over to SQL 2008 and found this peculiarity:
DECLARE @sql varchar(1)
SET @sql = NULL
On my SQL 2000 machine that code returns 0, but on my test box running SQL 2008 it returns 1 no matter the compatibility level of the database (80 or 100). Is there a global setting / flag that might affect this behavior? Or is it just
a design difference in the two engines?
I haven't turned up anything when searching elsewhere, hoping someone can shed some light.
I don´t know if it is possible to prevent SQL server 2005 from writing a query or a command to the cache!
I´m writing a procedure witch witch will get the unpaid invoices and send them by SMS to the customers mobile.
while writing the procedure SQL buffers the URL witch I´m sending to the webbservice that means that I´m geting every time the same result from the sebbservice if the URL is not changing.
Is there any ideas how to go arround the problem I´m wring the procedure in a production envirement?
I'm a novice in writing SQL-code. Last time I did it was about 10 years ago, but now I've run into a situation where I need to get a quick refresh. What I basically want to do is an automated export from each table that contains data in each database to
CSV-files, except the system databases, and store it in a directory structure.
We have started version handling some of the data in our databases, and to make it easier for the developers to know which data is versioned we've decided to setup a database with only that data, and then export it after every change to files.
So far, this is what I have:
select 'exec master..xp_cmdshell'
+ ' '''
+ ' ' + TABLE_CATALOG + '.' + TABLE_SCHEMA + '.' + TABLE_NAME
+ ' out'
+ ' c:\Temp\'
+ TABLE_CATALOG + '.' + TABLE_SCHEMA + '.' + TABLE_NAME + '.csv'
+ ' -c -t; -T -S' + @@servername
where TABLE_TYPE = 'BASE TABLE'
This gives me a list of exec-commands for each table in a database. What I need to add, that I don't kno