Viewing 15 posts - 6,856 through 6,870 (of 13,469 total)
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...
August 31, 2011 at 8:24 am
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...
August 30, 2011 at 2:40 pm
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...
August 30, 2011 at 1:52 pm
Math.Ceiling(3.99) will round it up to the nearest integer...is that what you want? so Math.Ceiling(3.09) =4 also.
August 30, 2011 at 1:48 pm
Charlie-551146 (8/30/2011)
No Sybase installed.
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...
August 30, 2011 at 12:34 pm
[:slice_number
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...
August 30, 2011 at 10:56 am
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...
August 30, 2011 at 10:35 am
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...
August 30, 2011 at 10:16 am
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...
August 30, 2011 at 10:06 am
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...
August 30, 2011 at 9:52 am
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...
August 30, 2011 at 6:34 am
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...
August 29, 2011 at 2:53 pm
R.P.Rozema (8/29/2011)
Good luck explaining this to your teacher 😉
🙂
August 29, 2011 at 1:39 pm
Guras (8/26/2011)
August 26, 2011 at 5:07 pm
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...
August 26, 2011 at 3:04 pm
Viewing 15 posts - 6,856 through 6,870 (of 13,469 total)