What is the process that actually does the data transfer? Is it some kind of .NET service or SSIS or something else?

Have you tried doing a server-side trace to...

There are some potential ways to "hack" this in the SQL, but this is really a display issue and should thus be handled in the .NET code. It's been...

Also the unicode datatypes NCHAR and NVARCHAR do have a maximum size of 4000 as each character takes 2 bytes.

Options:

1. sqlcmd - create a batch file that uses sqlsmd to connect to each server that executes a saved sql script against each server

2. PowerShell - create a...

You can use the Default Trace, IF it has logs back far enough as it only has up to 100MB of data. Here's a query that should find it,...

That's why I said "IF". MY SQL Servers are all running 2005, but I have the 2008 tools (SSMS) which allows me to...

I'd start by reading this to get an understanding of the options available. I think, and I'm not a full-text expert, you would want to use the FREETEXT function

If you have SSMS 2008 you can run a multi-server query, see this blog post[/url]. If not you could do a batch file or cmdexec job that uses sqlcmd...

Oops my bad the code should be:

If Object_Id('tempdb..#temp') Is Not Null

Begin

Drop table #temp

End

It is...

There are some posts on the duplicate thread found here. I'll be adding new posts to this thread.

Is the employee number parameter a text box or a drop-down list?...

Add a GROUP BY to the outermost select or a DISTINCT.

If you are using SSMS you need to connect to the other server and then run the statement in the context of the correct database. First you need rights...

By default Reporting Services logs report execution in the ExecutionLog table. It only keeps the data for 60 days by default which can be changed. See this Article.

"Might" is a noise word, thus it is not contained in the full-text index. You need to remove it from the noise words file and re-populate the index.

This comment really doesn't have anything to do with your question, but does pertain to the code you posted.

You start your stored procedure with Drop table #temp. If the...