Quote:
Originally Posted by radhamohan
hii...
i m trying to find the Unique key and the foreign key reference in MS-SQL.
plz any one advice me how to do this.
thank u.
radhamohan
Hi:
I would like to find out if there is any way of telling a particular report is executed by a user-click event or fired by a schedule event.
Here are my two use-cases:
1. We want fire different custom methods in ON-DEMAND and ON-SCHEDULE executions
2. On the final report, we want to show "This report is generated ON-DEMAND by user X" or "This report is generated ON-SCHEDULE"
Please let me know,
Thanks
Yared
You can look in the ReportServer DB ExecutionLog table where the username is recorded.
Hi
I have a problem where I must compair an import table with a local datatable and import rows that are missing and correct the rows that are different.
How to best do this?
I was hoping to avoid cursors
thanks
Walter
hi
what is simple is just refer to the database
and get the rows from current db and insert the sam in target database
use not in clause in source Db so u can take out the duplicates
I hope u ll be geting it right
TechiTawa|||walter_verhoeven wrote:
Hi
I have a problem where I must compair an import table with a local datatable and import rows that are missing and correct the rows that are different.
How to best do this?
I was hoping to avoid cursors
thanks
Walter
you need an upsert (update /insert) statement
unfortunately upsert is not a supported keyowrd in sql server right now but
there are work around.
see this links
http://sudheerpalyam.spaces.live.com/Blog/cns!1pKCMhBsSwPMevqFfdi-3JgQ!198.entry
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=58353
technique:Hi
I have a SQL Server 2005 database running. When I run some ddl changes, I want to find all the procs/objects that get invalidated because of object not found error.....
Is there any way that I can look up in sysdepends or other tables to find information about this.
Regards
Imtiaz
You can query the system view sys.syscomments for any procedures or functions that reference the objects. The text of each is stored in sys.syscomments.text.
Hi
I am using SQL Server 2005 Developer Edition.
I want a list of the following things from the database: -
Table Name , FileGroup Table resides on
Table Name, Index Name, FileGroup index resides on
To put it simply, consider the following example:-
Lets say I have a table XYZ in my database created on Filegroup F1. It has a PK PK1 nonclustered index on Filegroup F2.
List1
-
XYZ F1
List2
XYZ PK1 F2
Please do not tell me of sp_help <table> option
Regards
Imtiaz
For the table XYZ
select OBJECT_NAME(i.object_id) [Table_Name], ds.name [Filegroup_Name] from sys.indexes i join sys.filegroups ds on (ds.data_space_id=i.data_space_id) where object_name(i.object_id) = 'XYZ' and i.index_id=0
--This will work when the table does not have any clustered index on it.
For the non clustered index,
select OBJECT_NAME(i.object_id) [Table_Name], i.name [Index_Name], ds.name [Filegroup_name] from sys.indexes i join sys.filegroups ds on (ds.data_space_id=i.data_space_id) where object_name(i.object_id) = 'XYZ' and i.name='PK1'
For more such catalog view queries
http://msdn2.microsoft.com/en-us/library/ms345522.aspx
