..."But you can define other unique indexes on a table that will enforce uniqueness on other combinations of columns."..

How is this done for a single column ? ie UserGroupKey !

Thanks...

This what I am going to do...SQL server 2005

UserGroupID as Identity, increment as 1, Primary key

UserGroupKey as BigInt (filled from function that produces date/time/ms, it also must be unique)

NOTE: as...

Date time with milliesecound, that create a great chance of uniqueness, would it not !

condition: You dont have 1000s inserts in a split second.

You missed my question in my last posting...

Thanks, good response.

The table will suffer deleted records.

I like the idea

One field for UserID (no users 100 to 10000)

another for datetimecalc

Yes maybe I making too complicated, even tho deleted...

This is the scalar bigint function that I will use to get my unique ID

NOTE: I do not need to insert 100's of records in a row, so I can...

.."Which do you think will be faster if you have 5000 files with 5000 lines each for a total of 25 million lines of information to load into an array?...

Sorry I didnt make myself that clear,,,

Whats fastest, when you need to pull one TEXT file up into the asp.net application.

1) Pulling a single (say msft.txt) txt file out of...

very good point...thanks, and I will lock them all up...

So if my passPhrase is "The moon is round"..

I should not put this in my codebehind in a string variable, that I should encrypt up with "System.Security.Cryptography"

code like...

I know how to shrink the tempdb, its the fact that it wont shrink.

I use method 2 from link ...

Why wont it shrink, what could be the causes !!!

So simple, works a treat, thanks.

The settings in the operating system were not set for AM and PM. They were set as NULL. Hence I saw nothing come up.

Go Control Panel time settings.

I have Enterprise manager v8

.."chose AM or PM"...

Either I am blind, I cant see this anywere ?

I go in EM

SQL server Agent

Select My job

Select Properties for the Job

Select Schedules

Select Edit,...

I cant log on to run any queries in SQL Query analyzer.

I get time out of QA and EM, I cant connect to SQL full stop.

Can I run SQL from...