Recent content by Tomi

Thanks for the answer. Tomi

I have couple of SQL servers with SQL 2005 SP2 GDR2 (9.0.3054).I would lke to upgrade to SP3. Do I have to apply the cumulative update 10/11 and then upgrade or Can I upgrade directly ? What is the best method to upgrade? Tomi

Is there any system table or view that stores the last population date of Full text catalogs? (SQL 2000 or SQL 2005) Thanks Tomi

I appreciate this.Thanks mrdenny -Tomi

Thanks SQlbill; ptheriault - sp_who2 basically selects from the sysprocesses table. Tomi

I have come across this more than once: When looking at sp_who2 'active' for blocking information there may be several spids that may be involved in blocking say for eg . spid 177 blocked by 210,210 blocked by 161, 161 blocked by 191. But in the spid list 191 is not there. Has anyone come...

Is there any specific daylight savings time patch for SQL 2000 or SQL 2005 ? Thanks Tomi

The max. memory is not set.It is set to use dynamically Thanks Tomi

Hi My server (dedicated SQL system ) has 3 GB of physical memory and it runs SQL 2000 standard ed. My system admin said that that SQL std. ed. can only see upto 2GB.But when I look at the Total server memory and Target memory it is always showing only 1.6gb. Why is it showing 1.6Gb when it...

If I create a database using a windows account say domainA/user1 and if for some reason if the user( ie now the owner of the db) is deleted or disabled, will the database access be affected for other users? Thanks Tom

Hi , I had some issues with 2 databases which was replicated . so these databases were deleted and replication was also deleted, but under the publishers (under replication monitor) there is still those two names with a red X. When I try to delete these it gives the error 'Error 21776 :database...

I had turned on trace(1204) on my server and from the log seems like 2 SELECT statements are involved in the deadlock. How can a select which puts only a shared lock cause this? Any ideas ? ResType:LockOwner Stype:'OR' Mode: S SPID:307 ECID:0 Ec:(0x291B7560) Value:0x1e Victim Resource Owner...

Thank you , Is it possible to create the file , so that a new file is created when the system date changes and filename indicating the date and time also ? Tomi

Is there any function or command in TSQL to check for the filesize. ? I need to write the output of a query continuously to a file with filename qryout_200505120150200( timestamp) and when the file reaches say 100 mb it should create another file with the timestamp Are there any scripts...

Hi, The transaction log for my database have grown so huge. I don’t want to keep the transactions , but want to trim it and put in on simple recovery mode. I would like to create fresh log file for the db. If I stop the services , detach the database and attach only the mdf file, will I loose...