Okay, yeah tabs are always a problem. I have SSMS use spaces so that's probably why I don't have any issues.

I just cleared my cookies, and clicked on an email link to The Thread and went directly there without being logged in. Of course I just logged in to...

I had noticed that I was not asked to login when uses links from email, but I was, this was a couple of weeks ago, taken to the correct page....

How do you know what to set token_status to in Tab_Token_Details?

Is you current process doing an insert into Tab_Token_Master, then looping through and inserting the correct number of rows into...

Well, I'm not sure you provided enough information to give you a good answer. So here are some questions I can think of:

Are all the tables in the same...

;

with CTE(Acct)

as (select

...

I think the error is actually "Truncation may occur...". By default in the Excel data source the length of character columns is set to 255 and this error is...

It would be much easier to help you out if you posted the code. The snippet you have posted should not be causing any performance issues as it is...

SQL Server Standard cannot be installed on XP/VISTA so you should only have the option of installing the client tools. The only things I wouldn't install might be samples,...

When the ptf's were applied to the AS400 did you apply the updates to the ODBC driver on the SQL Server? This might solve your problem. You could...

I don't know how you are going to compare them then because the name is not the same, nor is the index_id going to match at that point. I...

Eswin,

There is not a similar script for 2000 because 2000 does not have the default trace. You can create a trace in 2000 that mimics the 2005 Default Trace...

The procedure does not return a result set. The 0 or 1 is the RETURN value of the procedure. So you need to run it like this:

-- variable...

The custom component was done in VS2008 so it won't open in VS2005. You could open it in a text editor to see the code.

I'm not sure what you...

You might find some help in this article[/url]. It does not directly address your issue, but it does deal with using a Script Component to read a file line...