i was trying the new EXCEPT operator of sql server 2005 to get the rows from first table which are not there in the second table. its working fine....
SQL Version - SQL Server 2005 Standard Edition, SP 1 I have a database which is Broker Enabled. We use Query notification extensively and the...
I know there is no way to grant permission for a login to run profiler in SQL 2000 other than adding that login in SysAdmin Serverrole. in one...
Hi, Very brief description of our architecture. Our OLTP production database is having line items which is to be aggregated and shown to High...
I have designed a small Data warehouse architecture which is implemented using SQL Server 2005 Analysis Service. I have few datamarts and I am able...
Hi Friends,<br /><br />yet another milestone in my SQL Server journey. i just got certified as MCITP Database Administrator in SQL 2005 today [<img...
Wish you all a Bright, Inspiring and successful new year. <br /><br />[<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br /><br...
Hi Experts, Is there any way to generate only foreignkey script(CREATE /Drop ) in the database. ie. without Table script. thanks Madhu
Hi All, We have ASP.net 2.0/LLBL Pro Gen application which is hitting a SQL 2005 Standard Edition(SP 2) Database on Windows 2003 SP 1 . While...
hi, I have report files which is created using SQL 2005 Reporting services. My front end is VB6. how can i connect to this report from vb6. Madhu
Separate names with a comma.
