LOL, maybe ask your boss and see what he/she thinks.

I'll have enough apps to review for Exceptional. I'd hate to think how many I'd get for acceptable :w00t:

I don't see anything weird there. Is there something I'm missing? Can someone post a screen shot.

Peter Maloof (5/24/2011)

I'm not a...

create table UserTracking

( trackid int identity(1,1)

, userlogin varchar(200)

, logintime datetime

)

go

grant insert on UserTracking to Public

Change your trigger:

CREATE TRIGGER connection_info_trigger

ON ALL SERVER

FOR LOGON

AS

BEGIN

insert UserTracking (userlogin, logintime)

...

Amazing amount of stuff in RTF. The Word files are XML storage, AFAIK, so you can even store those, but you need an interpreter to render them back.

The transformation to...

Search encryption programs, or check for your OS. Win 7 has some built in options, including the ability to encrypt flash drives. Same for some of the Norton/Symmantec products.

I like using a logon trigger to track this, grab the IP and go from there. Best to just get the info you can, and then handle it offline by...

Rich text, AFAIK, isn't unicode. It's markup inside the text that is interpreted by the editor. So if I make a set of bold text and a regular text like...

Code to show duplicate values, without constraint (SS2K8R2)

DROP TABLE dbo.MyTable

CREATE TABLE mytable

( id INT IDENTITY(1,1)

, mychar VARCHAR(10)

)

GO

INSERT mytable SELECT 'A'

INSERT mytable SELECT 'B'

INSERT mytable SELECT 'C'

SELECT * FROM dbo.MyTable

SET IDENTITY_INSERT...

No idea on relationships, but nvarchar(max) and varchar(max) for Latin data are the same. Only if you are storing data requiring Unicode does this matter.

This might help: http://geekswithblogs.net/pakistan/archive/2005/04/19/36884.aspx

You need to SELECT the data from the table, but the client has to deal with the stream.

bcp makes the most sense to me. Easy to use, upgradeable across versions.

http://en.wikipedia.org/wiki/Reentrant_%28computing%29

It means the same section of code can be executing from one user (or process) and a second user can then use that same code again and start executing it...

Stefan Krzywicki (5/24/2011)

Plus, if the person gets undercover help and succeeds, they're going to be asked to do more that they're going to need help with. It becomes a never-ending...

Gail is correct, the shrink is bad, and the reorganize will rebuild indexes. You can read here:

http://msdn.microsoft.com/en-us/library/ms188964.aspx

When that runs, it will require space in the database, and it will log...