instances use the other slash...dunno if it is a typo:

my server is LOWELL\SQLEXPRESS, or LOWELL\SQL2008 for my other instance....could that be the issue?

well i saw one thing we can fix right away so far:

there is a scalar function dbo.Get_LocalDateTime that is called multiple times; that needs to be changed to a inline...

keyun i'm sure the issue is related to attempting to use a trusted connection.

if you pass a SQL username and password, your command to bcp via xp_cmdShell will owrk.

to see...

sam-1083699 (6/24/2010)

---

HI Friends,

I'm currently working on a server where lot of transactions will be running and this server is a very beefy server with 4 quadcore processes for a...

you cannot use a trusted connection via sp_cmdShell. SQL doesn't use your credentials after you've connected to SQL.

this is a common security misconception. The problem is that when you...

you do not need to put the command in a while statement; .Replace will replace all instances of the comma in one single function call.

there is a Connect article about how Raiserror does not work the same with XACT_ABORT ON as it does when in a try catch block:

http://connect.microsoft.com/SQLServer/feedback/details/275308/have-raiserror-work-with-xact-abort

annoying, you would expect raiserror to...

yeah configuring the server like that is something you like once a year at the most, and only when you needed a functionality you didn't need at startup;

glad i could...

instead of having a rollback command as the body of the trigger, you can send an email instead....so you can get notification that it ALREADY happened and not rollback the...

in small letters, right next to the words "Configure Surface Area for localhost" there is a link that says "change computer"

click it and put in the name and connection info...

the error is self describing...go to Start>>Programs>>Microsoft SQL server and find the Surface Area Configuration....scroll down to database mail and enable it.

you want to prevent one specific table or all tables from being dropped?

i assume you mean some people have the rights/roles to drop the tables, you are not going to...

the secret is to use cid:attachedimage.gif for the source file.

here's a setup and working example:

I'm attaching the results of a query, and i copied the SQl server logo to my...

Note that this has syntax issues with what stewart posted if you are not using SQL 2008; 2005 hates you for a few things (no += operator, can't...

can any Organization have more than one CompanyNumber a CharityNumber?

if the answer is no/never , i'd put those columns in the Organization table; if the answer is maybe/not sure, i'd...