Viewing 15 posts - 61 through 75 (of 121 total)
greg eze (1/23/2009)
FROM SMS.dbo.v_R_System sys
JOIN SMS.dbo.v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID
JOIN SMS.dbo.v_FullCollectionMembership fcm on sys.ResourceID=fcm.ResourceID
WHERE fcm.CollectionID=@collection and DisplayName0 LIKE (Select '%'+ProductName+'%' COLLATE Latin1_General_CI_AI AS ProductName from Sw)
Rewrite above...
January 23, 2009 at 2:21 am
What problem are you facing while designing this structure?
January 21, 2009 at 2:14 am
There is no such trigger. You can use Job instead.
January 21, 2009 at 2:10 am
Check for temp table creation in your SPs. Temp database size also increase for some sorting/aggration operations.
January 20, 2009 at 2:19 am
You are welcome Praveen,
This is the very easy to do. But it may case security issue, if you don't want your user to have access of all object of database(s)....
January 19, 2009 at 3:32 am
In Object explorer,
- Explore Security Node
- Explore Logins
- Right click on your user and click on property
- Goto Server role tab and tic Sysadmin
-...
January 19, 2009 at 2:49 am
praveen kumar (1/19/2009)
I have created a job on webserver login with window authentication. bcoz while login with username & password or (SQL authentication), SQL Agents jobs option is not comes.
Give...
January 19, 2009 at 2:31 am
The user which you are using does not have permission to execute this SP.
Which user you are using to execute the SP? and what the role of that user?
January 19, 2009 at 2:22 am
You can use ALTER TABLE statment...
But why do you want to drop clustered index on PK? Is yous PK generaation not in order? Or want to created clustered index on...
January 16, 2009 at 5:32 am
You can use different DB comparision tool
see this link http://www.sqlservercentral.com/articles/Tools/64908/
January 14, 2009 at 10:21 am
You might not have GRANT on this table. Check with your administrator about the access.
January 14, 2009 at 2:53 am
Viewing 15 posts - 61 through 75 (of 121 total)