Sure that is possible. Just to reiterate, I recommend doing something asynchronously with a job or windows service instead of a trigger. Even if you have to add...

I suppose I should mention that I also did some work for jumpstarttv as well, so there should be some videos coming from me there as well.

I actually don't know...

I would not claim to be good at SSIS either, but I would assume there is a way to do what you need and that it will be faster than...

Great I assume that the table is being built correctly in SQL Server, but your error is coming from a .NET application and I'd need to see the .NET code...

Have you viewed the SQL string that is built and verified that it is valid in SSMS? Just a Response.Write(SQL) so you can verify the string is bing built...

If this is actually the line of code:

sql = Update web Set answer1='" & answer1 & "' where identity ='" & identity &

Then it isn't going to work as...

Can you restore the backup to another instance? It may be that the database has some enterprise only features as well or is too big (>4GB) for SQL Server...

Have you tried using SSIS?

Brandie,

I'll see you there. I was planning on hitting the JAX event, but couldn't. I have one session on Getting Started with SQL Server Profiler that I...

I basically agree with Paul that I have typically created my own jobs for maintenance. More out of habit than anything being wrong with Maintenance plans. I would...

I think the Row Count Transform is exactly what you are looking for.

Check out http://www.jumpstarttv.com. This site has just re-focused and over the next month or so there will be many videos added that I think will be helpful to you....

I have not read the whitepaper, but my assumption is that MS means that LINQ is now available within the SQLCLR in 2008 whereas it is not available in 2005.

There could be several issues. Is your UI program getting an error messages? Are you guaranteed to have connectivity between the 2005 server and the linked 2000 server?...

Can you explain your reason for needing this? I think the designed way for SSIS to handle this is to use the Row Count transform.