is it a requirement to use linked servers? there is a better way of exporting your data to excel. Query it using the VB .net app and then easily export...

you are using the table values function in a wrong manner. create your function as a scalar function.then it should work fine. let us know if you still have problems

its quite difficult to help on this one with out the data. BUT

comment out most of your code and debug it bit by bit, that is the best way for...

can you check in your System Event Log or the Application Event Log? are there any entries that are suspicious related to your app?

Melissa Scheuer (4/23/2008)

---

We are creating a schedule in SQL 2005. This schedule is constantly updated and is continuous. We need to add tasks to this schedule that could go either...

you can create a .net assembly which reads your excel spreadsheet.

If it's a ton of columns (it looks like it is), you could build the insert statement into a dynamic command, and then use sys.columns to step through them with...

can you connect successfully if you use the management studio ?what if you use windows authentication are you able to connect?

no i don't think this is possible. you could try to use the USE in a dynamic sql statement.

Yasir, why do you want to call power builder from a stored proc?if you dont mind you can tell us your problem and then we can try to suggest a...

I like JohnG's solution. Daniela I don't know how much experience you have with SQL development but try to develop something that is somewhat futureproof i.e. scalable and robust

the problem with your solution is that you might over the limit for the characters. which sql data type are you using when passing your string.

I would be tempted to use clr and an external smtp server

What do you want to achieve, your question is rather confusing to me?

First thing that comes to mind is what has been said above and secondly you can consider sending...

you need to get a cpu license, where you will be buying a license for each processor on the machine running the sql server.

http://www.microsoft.com/sql/howtobuy/sqlserverlicensing.mspx

and the word doc

if still in doubt...