polo.csit (7/22/2009)

---

Hi all,

i am using sql server 2005

how to write trigger for......................

How to fire trigger each day automaticaly my table(select the...

Follow these steps

1. Ask your domain admin to create a windows group and and all these users to that group.

2. Create a login in sql server for this group.

3. Grant...

Hi,

Please refer to the following links. It may help you.

http://support.microsoft.com/gp/lifepolicy

http://www.microsoft.com/Sqlserver/2005/en/us/support-options.aspx

http://support.microsoft.com/lifecycle/search/default.aspx?sort=PN&alpha=sql+server+2000&Filter=FilterNO

http://support.microsoft.com/lifecycle/search/default.aspx?sort=PN&alpha=sql+server+2005&Filter=FilterNO

http://support.microsoft.com/lifecycle/search/default.aspx?sort=PN&alpha=sql+server+2008&Filter=FilterNO

In sybase we could disconnect the instance (connection) using "syb_quit()" command. Do we have any script available in sql server like sybase ?...

Hi Mahesh,

You cannot rollback service packs upto 2005. This feature is available in 2008

Can you post the complete error message and sp level of your sql server

Hi,

Count is an aggreate function which accepts only one input parameter. In your query you are trying to input two columns as input to...

Yes this is the correct solution. But I think it gives error as the X database on server B is standby. Wait for inputs from others here.......

Hi Amit,

Use this command. It will bring back from restoring state to normal. You can proceed further on how you want. Check this and let me know.

RESTORE...

Hi Giri,

Your question is not clear.

You are saying here you want to search

I give ...

Hi

I think its nothing strange. If you have multiple indexes on a table then it will definitely show repeating table names.

Use the below query

select o.[name],i.[name],i.[groupid] from sysobjects o,sysindexes i...

Hi,

Did you checkout sysindexes and sysobjects tables individually whether you have any duplicates. I think you did not move your indexes correctly. Can you post the code which...

What type of application are you using i mean webapp or gui based like vb app

Hi,

Please refer the below link for creating a cluster in virtual server environment. http://blogs.msdn.com/blakhani/archive/2007/12/31/how-to-create-sql-20005-cluster-on-virtual-server.aspx

Hi Sourav,

This link will definitely help you.

http://www.sqlserverclub.com/articles/how-to-deal-with-negative-spids-in-sql-server.aspx