sgambale (8/17/2010)

---

Thanks for the replies. It makes sense that 1, 2, or 3 blanks is treated the same (with the entire column filled with blanks), but the empty string...

if you used the GUI, you can rename a stored procedure without having changed it's underlying definition. that was at least true in SQL 2000 with Enterpise Manager.

so i could...

that is...

the LEN() function ignores trailing spaces, even on a CHAR data type, where the DATALENGTH() function respects the spaces;

so to find exactly two trailing spaces in a column:

SELECT * FROM...

you cannot modify the built in roles in any way;

what you want to do is...

ok i'm pretty sure you are pasting untested code, because the tables you pasted do not have the same column names as the trigger;

i'm not surprised nothing seems to work...the...

well, the way i read your trigger, it should be working just fine.

if you run this commnad, do you see changes in the status?

SELECT i.AppointmentUID,i.AppointmentStatusUID,StatusStartTime

FROM AppointmentStatusTransactions

GROUP BY i.AppointmentUID,i.AppointmentStatusUID,StatusStartTime

...

the UPDATE() function is so misleading.

the UPDATE() tests to see if the column name was specifically included/named in the update or not...it does not test if a value changed.

what...

ok, now it sounds like they added a custom data type; no big deal, but a bit harder to figure out.

In SQL, you can declare your own datatype, and decide...

every carrier has support for...

it's not possible. SQL Server will only run on a Windows operating system. so you can access and use a sql server from unix, but it cannot be hosted on...

Jeff run this command:

EXEC sp_help gl_text

a lot of results weill come up, but towards the bottom you should find all the foreign kesy in the table...scroll right...

servername\instancename is resolved by the WINS service and the SQL browser. that's not exposed to the WAN, just TCP/IP addresses.

since you are using a firewall to the outside world, you...

whenever you upgrade a system, or restore a database to a higher version, as i understand it the statistics used to get the database may be mis-interpreted by the newer,higher...

well lets try an example;

I invite everyone to build off this example and offer better suggestions.

lets say YourDomain\bob and YourDomain\tom are users who currently are in the builtin\Administrators group, have...