Search results for query: *

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 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

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...

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...

May be this is a stupid question : Is it possible to set up transactional/snapshot replication bidirectional ?ie one pushing the changes to the other and the other pushing changes to the first ? This is an idea for redundancy - not considering log shipping or clusters thanks Tom

With SQl 2000 I had created a publication on srv1 and Iam is trying to do transactional push subscription to srv2 .When I select push the subscription on srv1 , the srv2 is not listed under enabled subscribers- how do I enable the subscriber on srv2 ? Thanks in advance Tomi

I have a database which has a datafile of 81 gb of which 42 gb has been used and 38 gig is free. The log file is only 18mb .How do I shrink the datafile/db so that its size would be at 42gb (to regain the free space)? Thanks Tomi

When I use dbcc inputbuffer for a spid it only mentions as - sp_executesql;1.How can I find the actual query involved? In profiler do I need to select some specific events & columns for this ? Thanks Tomi

According to MS the o/p from sysprocesses table gives us info about the wait process as RID DatabaseID:FileID:PageID:Slot How is it possible to find out the table or object involved from the pageid ? Thanks Tom

Hi, Where does SQL server store the stored procedure and its text(code)? Is it possible to retrieve that from a table or view ? Thanks Tomi

Hi, How can I find all the objects(Tables,views,SPs etc) that a particular SQL user login has access to (The user may not be the owner but may have rights on the objects)? Pls help Thanks Tomi

I deleted a database thru the Ent.Mgr and database was deleted , but the process seemed to be hung .So I went ahead and killed the process .When I give the sp_who2 ,now it shows status as runnable and command to be killed/rollback When I give kill now it says 'SPID 84: transaction rollback in...

Hi, When I do a manual failover from node1 to node2 all the resources seem to move from one to another indicating pending .....online. But when sql server service moves over it says failed , and then moves over sucessfully. What could be the likely problem.This has happened more than once...

Hi, How can I add a new drive to the array and map it as a logical drive to be seen in SQL Server cluster.Can somebody give the steps for this. Thanks Tomi