Thanks Steve, I created Stored procedure to kill users based on last_batch field.

do you have any idea about Dashboard technology, our district wanted to implement this new technology. I have...

Thanks for your reply.

I think first we need to create logins for users. let's say there are 1000 users in Access database. Do I need to create 1000 logins...

Thanks a lot.

I can consider both the options.

Sorry for making you confuse. I actually figure out the problem. I use xp_cmdshell to solve this problem.

I wanted to rename all the files in the folder with different name...

I tried according to the article and getting follwing message.

Error 7399 OLE DB PROVIDER 'Microsoft.jet.OLEDB.4.0 reported an error

Thanks for your help.

Thanks guys. It's truncating.

Thanks a lot.

I did setup transaction replication once using pubs database at home and it works fine. I have not setup at the client site yet. Now I got...

I think you are right. May be these entries are all active.

Actually , we are running Altiris application on the sql server. Altiris application is similar to PC Anywhere and...

Sorry about the last reply.

I used the command dbcc sqlperf(logspace)

and I get following result. so it is over 70% ,

database log size log space...

Thanks for your reply.

My transaction log is not full. I am just checking the log file and is growing very fast.

I run the dbcc sqlperf(logspace) command and get following result.

database...

Greg .. Now my transaction has grown to 6521 but it not truncating. can u please tell me how u come up with this number.

Simon .. You mentioned that it...

Vishy.. don't you think that when we backup the log files it automatically truncate the log files.

Just for the space purpose.

It there any way to figure if the transaction log has been truncating.

Thanks for your help.

I don't think I can use soundex function for this. May be I can match all the characters in one string and then calculate how many...

Thanks fro your reply.

If it is a space then I can use ltrim fuction but this is other than space. when I use len function of 'ASSP ', I get...