Like Jo pointed out, it's just a variable in the connection string, and really easy to change.

you can even make SQL Server Management Studio show up with a different applicaiton...

others will chime in with more details, but here's the basics as i understand them:

SQL server builds a query plan to access the data for the stored procedure based on...

there's an extended stored proc that can help, i think

here's an example of the syntax:

EXEC master..xp_logininfo

@acctname = 'mydomain\lowell',

@option = 'all' -- Show all paths a specific user gets his...

Math.Ceiling(3.99) will round it up to the nearest integer...is that what you want? so Math.Ceiling(3.09) =4 also.

Charlie don't hate me, i'm just the messenger, but that is defintiely the context menu from SyBase's bcp /?

http://manuals.sybase.com/onlinebooks/group-as/asg1250e/util/@Generic__BookTextView/10086;pt=10086

try changing the path to bcp to explicitly go...

THAT makes me thing you are calling the SyBase bcp.exe and Not the SQL Server's version. SQl doesn't have a slice.

do you have SyBase client tools installed?

if you change the...

SQL should have a show on Discovery Channel called "Memory Hoarders"..once it gets the memory, it does not let go, up to the limit of what you allowed at set...

John when a proc runs quick in SSMS and slow elsewhere, one of the first things i look for is parameter sniffing.(you can search for that term on this site...

is there a message from the mail server itself? unable to relay, mailbox full, etc?

that's probably where the error is, my server requires a username and password to authenticate via...

Charlie I only see two things.

i think the call to the procedure has to be fully qualified, i always put the servername.schemaname, but that might not be an issue.

the other...

this seems to work for me;

i'm distilling each date to be the # of days fromt he beginning of the year.

there's alot of dateadd/datediff in there, so it can be...

at least some of your column values are not blank strings and also not convertable to a datetime...might want to look at it with this:

SELECT [Closing Memo Date] As BadDate,*

FROM

YourTable...

🙂

Guras (8/26/2011)

---

But does 'DB_DenyDataWriter' prevent them from being able to create and drop objects in that database? In other words if I can give the role read and insert and...

fiarly straight forward, since by default, they have no rights to do anything that you don't give them rights to.

here's a very simple example, but esentially you want to do...