db042188 (5/8/2013)

---

thx. How 'bout 64 bit ssis pkgs. Do they run with excel. I think you would know if you are running 64 bit ssis by seeing...

no it will not step on the existing drivers/installation, it forces a side by side install instead, so both the 32 bit and the 64 bit are installed and available...

there is a very similar issue when adding linked servers for Excel;

I tripped over this before , where Office 32 bit was installed on my server, and you get in...

ok here's a slightly modified version, showing exactly your problem, with a text field that must be converted;

i had to generate fake data, and assume a table structure, because you...

agreed, but if he auto generates an overlapping...

i f he's inserting into a constraint, and one of the new generated values happens to be the same as an existing value, i'd expect an error;

for example, just based...

yeah the server roles would need to be scripted as a separate step;

this is what I have saved in my snippets for doing exactly that, if it helps;

SELECT 'EXEC...

your xml was not well formed, so i couldn't use it as an example to show you:

you will have to convert(xml,YourTEXTColumn) to use this logic;

here's a couple of ways:

DECLARE @xml...

I'd recommend using MicroSoft's sp_help_revlogin instead; it simply produces a script you can run in a few seconds;

there's different versions, depending on SQL 2000 vs 2005 and up,...

for the filename stuff, somewhere abovee your code, you need to construct the filename:

declare @attachmentfilename varchar(100)

SET @attachmentfilename = REPLACE(CONVERT(VARCHAR,GETDATE(),101),'/','')

-- formats 05/07/2013 and removes slashes to 05072013

+ 'Attachement.xml'

...

sure hope we can help, it's honestly very satisfying to help someone eliminate a cursor when possible.

ok, you've got a cursor, and it's doing something...SELECTING and matching with your WHERE...

not directly like that, no.

If you have a stored procedure that returns data, you can insert it into a temp table, and have the cursor go through THAT.

no, adding a...

i create a a view for every trace i create; it's just much easier to access.

from there, i can group the data however i need to, since it's just an...

my first guess looks pretty good;

just using row number, and joining the data against itself:

WITH MySampleData

AS

(

SELECT row_number() OVER(partition by date order by date,time,seqno) AS RW,

*

from #tmp...

niladri.primalink (5/7/2013)

---

Hi SSC,

thanks for your reply. I need to check how many times my query has been modified and from which IP as the users are using the same user...