I don't think the log reader is working

Simply says that there are no transactions available. But when I go to my
production app and add some things it still says the same thing.
--K
please contact me offline on this one.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Kristy" <pleasepostreply@.here.com> wrote in message
news:e5gCnBRMFHA.3928@.TK2MSFTNGP09.phx.gbl...
> Simply says that there are no transactions available. But when I go to my
> production app and add some things it still says the same thing.
> --K
>
|||Okay, I sent an email to your account. Thank you.
--Kristy
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23hsrl5SMFHA.1308@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> please contact me offline on this one.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Kristy" <pleasepostreply@.here.com> wrote in message
> news:e5gCnBRMFHA.3928@.TK2MSFTNGP09.phx.gbl...
my
>
|||I haven't got it yet, please resend - you can also try hilaryk @. att.net
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Kristy" <pleasepostreply@.here.com> wrote in message
news:ec9gRFUMFHA.1948@.TK2MSFTNGP14.phx.gbl...
> Okay, I sent an email to your account. Thank you.
> --Kristy
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:%23hsrl5SMFHA.1308@.tk2msftngp13.phx.gbl...
> my
>
sql

I am practicing by building a PM Online App

In my Project table.

I have a column called projSeqNum (Project Sequence Number) I was with a fellow techie -data modeler- and I think it was just placed with an int data type. I think a 4 length.

My question is what would be the correct data type here. There could be 100's of thousands of unique Project ID's so I need something sturdy but not overboard.

Any ideas?

Should I use a varchar data type?|||

Hi

The int datatype should be fine - it allows for numbers up to 2,147,483,647.

If that's not big enough, you could use bigint, which goes up to 9,223,372,036,854,775,807.

HTH