Lun

i have " preemptive_os_wsasetlasterror " highest wait type, 31% of wait types, , waits on average 2.24 seconds! what that? , how improve it?   i'm saying fishy here - or system flowing gently, 1 of few things takes time. again, 2.24 s per call set error code? not sound normal. what can dba? not think. if have genuine performance problem can relate wait state, need give guys , gals @ css call. seems me time serious windows debugging here. then again, if system running fine, should smile , happy. :-) SQL Server  >  SQL Server Database Engine

sorry if repeat question dont know doing wrong here. have created stored proc when pass in parameter of sql login, passes through every database on server , returns perms sql login on every database. request 1 of our managers wants able see users database perms @ point in time running proc. not 'sa' himself, idea create proc set execute sa. whenever ran info needs. so proc works fine when run 'sa'. need add "execute sa" command wont let me follows create procedure dbo.usp_checkuserpermsall -- add parameters stored procedure here @user varchar (255) with execute as 'sa' as begin -- set nocount on added prevent result sets from set nocount on ; declare @dbstable table (dbaseid int not null , dbasename varchar (255)) declare @wdbid int , @dbname varchar (255), @sql2 nvarchar ( max ), @sql nvarchar ( max ) ...... ...... i follwing error msg 15151, level 16, state 1, procedure usp_checkuserpermsall, l...

sql 2005 windows server 2003 sp2   for reasons don't want go here, having manage password changing of sql logins across several servers.  in order accomplish this, having validate new password meets current domain policy without changing login's password @ time (it's synchronized later across several servers @ specified time).   is there way verify sql login's new password meets domain policy?  api's have seen checking require windows account check.   thanks!   brandon you can use api: http://msdn.microsoft.com/en-us/library/aa370661(vs.85).aspx  - api used sql server itself. SQL Server  >  SQL Server Security

hi everyone, i have problem installing server management studio. installation seems fine until @ last point , rolls back. tells me installation interrupted. have tried rebooting pc no avail. can me please? if information of help, i'm running windows xp sp2. have sql server 2005 , vs web developer installed on machine. cheers either download ssmse internet , install below link else try below steps http://www.microsoft.com/downloads/details.aspx?familyid=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796&displaylang=en   insert sql server setup dvd goto x:\tools\setup folder , execute sqlrun_tools.msi start installing sql server 2005 client components (x: cd drive letter) SQL Server  >  SQL Server Express

it possible browse wp7 application in browser? live in norway , want see available apps, dont have wp7 phone (and wp7 store in not open in norway). thanks! this best i've seen far, , quite frankly, it's pathetic best microsoft has got. http://www.bing.com/browse?g=wp7&qpvt=windows+phone+7+apps#toc=0 perhaps if microsoft hired developers instead of lawyers, or focused energies on worthwhile technologies (silverlight), opposed worthless technologies (html 5), they'd have decent web interface marketplace. Silverlight  >  Silverlight for Windows Phone

hi,       how solve error. please post maximum details can when asking question. important know when getting error, trying etc. this looks similar link,  have look http://forums.asp.net/t/1093903.aspx/1 satheesh SQL Server  >  SQL Server Express

hello, need sql queries. have 2 tables contain following fields advertiser_lookup  -advertiser_id  -advertiser_name data_snippet  -date  -advertiser_id  -site_id  -domain  -datacenter  -geo  -user_accepts_cookies? (true/false)  -user_has_data? (true/false)  -impressions  -spend  -requests_sent  -bid_volume  -total_bid_value  -total_wins i need queries following advertiser name. total requests sent total requests sent user data percent requests sent user data bid volume bid rate avg bid value (multiply answer 1000 cpm) win volume win rate impressions avg spend (multiply answer 1000 cpm) all highly appreciated. thank you. to started, here query total requests sent: select a.advertiser_name, sum(ds.total_requests) total_requests from   advertiser_lookup a join   data_snippet ds on a.advertiser_id = ds.advertiser_id group...