Viewing 15 posts - 6,871 through 6,885 (of 13,469 total)
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...
August 26, 2011 at 2:55 pm
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...
August 26, 2011 at 12:30 pm
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...
August 26, 2011 at 7:10 am
MysteryJimbo (8/26/2011)
August 26, 2011 at 6:54 am
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...
August 26, 2011 at 6:53 am
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,...
August 26, 2011 at 6:37 am
hellolasantha (8/25/2011)
@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...
August 25, 2011 at 8:37 am
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...
August 25, 2011 at 7:32 am
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...
August 25, 2011 at 7:25 am
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 ...
August 24, 2011 at 1:54 pm
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...
August 24, 2011 at 1:50 pm
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...
August 24, 2011 at 1:44 pm
google Translate for : marcio.staruck (8/24/2011)
Today I changed the SA password, but I am not able to login as SA and not as windows authentication.I really need help.
August 24, 2011 at 1:38 pm
maybe the stored procedure is in the master or msdb database, and thus was not migrated when that one database moved over?
August 24, 2011 at 12:39 pm
Div Goud (8/24/2011)
i am passing two parametres start date and end dateit will creating temporay table and generating result one
well, a function can only create a table variable, and...
August 24, 2011 at 9:08 am
Viewing 15 posts - 6,871 through 6,885 (of 13,469 total)