Mario the object_name() function has a second parameter for the database_id;;

i suspect that's what you need to add;

try this and confirm it fixes the issue...you'll see all i did was...

i think you can specify the port by adding comma portname to the server? my examples are assuming you use port 14433 as the port.

for avoiding the dash and the...

MysteryJimbo (8/26/2011)

---

I disagree.

I've just tested this on a table column with no constraints, fk etc. Ran the statement given which worked instantly. I then did the...

MysteryJimbo (8/26/2011)

---

Dont do GUI. The GUI is very cautious when it comes to altering tables and will more often than not copy data into a temporary table, rename the...

i leave mine unchecked, because if i'm going to change a table via the GUI, i know it handles all those drop/rename/new cosntraints automatically, so i'm not too worried;

I'm not...

sounds like you are changing a column that has FK or something on there that requires a drop and recreate fromt he GUI.

there is a checkbox that prevents that,...

hellolasantha (8/25/2011)

---

@Grant Fritchey

@Lowell

So

if i get a copy of particular result set and kept in the memory,

Do the key press interraction with the copy (which is in the memory)

would...

to me, the error looks like the Kitchen.bat is not found in any of the folders in the %PATH% variable.

the call looks like oyu expect it to exist inside...

I'd consider loading the datatable you want to search agaisnt ONCE, and then using a filter( if you are using a BindingSource) like bindingSource.Filter("SomeValue LIKE '" & sometextbox.text & "%'")

or...

In SQL Server Managment Studio, if you do Help>>About, what version do you see?

here's mine for 2008:

Microsoft SQL Server Management Studio 10.0.4000.0

Microsoft Analysis Services Client Tools ...

existing PDF's are just plain not editable, especially not from TSQL;

you'll need to generate a new PDF instead.

it's also possible to append two PDF's together, so PDF2 starts where PDF1...

i think this is because the client tools you are using are from SQL 2005, and not 2008;(that 9.0.0 stuff means 2005 to me)

can you try to do the same...

maybe the stored procedure is in the master or msdb database, and thus was not migrated when that one database moved over?

well, a function can only create a table variable, and...