Viewing 15 posts - 16,096 through 16,110 (of 39,970 total)
I've searched a dozen links and I don't find "partition lock" as a term in BOL. The idea is there, and even in the ALTER TABLE options, it does say...
May 25, 2011 at 10:19 am
By default, they have rights on the machine, but you can set up folders that don't allow the administrator access. An admin can take access, but that is noted and...
May 25, 2011 at 9:29 am
Thanks for the notes, and glad you liked it.
I know that Millenials is a generalization, and certainly people feel differently with that group. It encompasses people of a variety of...
May 25, 2011 at 9:27 am
I think that's a IE issue. I don't see that at all in Firefox. I'll have someone look at it
May 25, 2011 at 9:08 am
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:
May 25, 2011 at 8:59 am
I don't see anything weird there. Is there something I'm missing? Can someone post a screen shot.
May 25, 2011 at 8:34 am
Peter Maloof (5/24/2011)
EdVassie (5/24/2011)
The agile methodology using Scrum (and its variations) is by far the most effective way I have seen for delivering useable value to the business.
I'm not a...
May 24, 2011 at 12:36 pm
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)
...
May 24, 2011 at 11:55 am
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...
May 24, 2011 at 11:13 am
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.
May 24, 2011 at 11:08 am
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...
May 24, 2011 at 10:09 am
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...
May 24, 2011 at 9:58 am
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...
May 24, 2011 at 9:55 am
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.
May 24, 2011 at 9:32 am
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.
May 24, 2011 at 9:29 am
Viewing 15 posts - 16,096 through 16,110 (of 39,970 total)