i seem to remember that the biniaries that are the core srvice and stuff must be installed on the %systemdrive%, with no choice in the matter...you can move the databases,...

if you cannot use the builtin getdate() function for the current date and time,

you can stick the results into a temp table, and insert from there as well.

CREATE TABLE...

yes, opc.three's comment is the key; i testest it to make sure...for me i created a suite of tables and then 4 different functions and procs, all with GO statements...

see opc.three's post from the thread below;

i learned something here, since i was used to think that GO + BEGIN TRANS were not compatible, and now i know better:

http://www.sqlservercentral.com/Forums/Topic1125836-391-1.aspx#bm1125844

the hanging of the app from the command line is that messagebox dialog, guaranteed;

I hate to say this, but you'll have to check the 3rd party apps documentation to supress...

malachyrafferty (6/16/2011)

---

hi all

i have a 3rd party demo software called Crystal Command which lets you execute a crystal report in the background using command shell and save it/email it etc

what...

what's this post counter of which you speak?:-D

Kevin for me, to get a table based on select into, I usually use a WHERE statement that will guarantee no rows:

SELECT * INTO ...

WHERE 1=2

that builds...

SQLRNNR (6/15/2011)

---

If there is nothing about those 4000 records to be deleted that makes them similar to one another, then you have to delete 1 by one. If you...

select convert(int,'.') --fails

select convert(money,'.') --0.00

so if your data is only a period, what value did you expect?

i think you'll have to switch to dynamic sql instead for stored procs,views and functions...

edit: just plain bad advice/not needed. see opc.three's excellent comment below.

any possibility it's not a table, but a view or proc or a poorly named constraint or something that happens to be named 'sample'?

select

schema_name(a.schema_id) as SchemaName,

a.name as ObjName,

a.type

from...

actually, a user...

😀

One Procedure To Rule Them All? Lord Of The Rings Style?