Hi all, I need to create a DTS package that will on a daily basis transfer +- 150000 rows from around 3 tables holding around 18 million (and...
What are you trying to do with the schemas and templates? Regards Shaun World Domination Through Superior Software
The SET FMTONLY commands have something to do with returning metadata about the resultsets processed, I think I've read somewhere that even if you...
Where are you getting the error and what is the error description and number? It might help to show the GetResultSet method as well. Thanks Shaun...
As far as I know if you include the ApplicationName in the connection string and set it to the session var as you described then (presuming you're...
No problem found it : select nt_username from master.dbo.sysprocesses where spid = @@spid Thanks World Domination Through Superior Software
If you use windows authentication for you connection details is there a way to obtain the user login name in sql server for that connection eg in the...
Sorry about the multiple replies, the server was hanging and the script timed out when I posted back and after a refresh there were 3 replies! Also...
Thanks, I'll try that, I'm not sure why I was so stuck on doing it recursively. The limit for stored procs is 32 I think. Cheers Shaun World...
Hi All, Been hitting a bit of a brick wall, I was wondering if it's possible to have a UDF or SP and in it use recursion to navigate a parent/child...
Excellent, thanks alot Dave, just what I was looking for. Cheers for all the help guys. World Domination Through Superior Software
The problem with using the identity column is that I'd have to use something like 'WHERE identity_column_name < last_id' or 'WHERE...
Hi all, Maybe someone out there has an easy fix for this, hope so. Basically we have a table with a set of reports on. Each report has a report...
Thanks Satya, but I still don't understand why the rowcount is different as there is only 1 clustered index on the table and both queries result in a...
I've been working on some queries and have found that when queries have the shamefull * operator in them to retrieve all columns instead of the...
Thanks for all the help everyone, Bambola, you're a star! Cheers Shaun World Domination Through Superior Software
All, I've got a sql statement pretty much like the one below, what I'm trying to do is get the total of all the records returned select...
Hi there, You'll need to attach some javascript to the first select html control, use the 'onchange' event of the control to fire off some...
Wow, I obviously didn't get the first post, what a cool find. Cheers Shaun World Domination Through Superior Software
Are you sure the results didn't come back in a second resultset, I've heard of this happening before. Cheers Shaun World Domination Through...
Separate names with a comma.
