Lun

hello,    i have shapefile shows boundaries of zip codes in state. i imported them sql table , looks below. area perimeter zt39_d00_ zt39_d00_i zcta name lsad lsad_trans 0.016331593 0.86623369 2 1 44030 44030 z5 5-digit zcta 0.008550389 0.675197563 3 2 44048 44048 z5 5-digit zcta 0.030681297 1.290166752 4 3 44047 44047 z5 5-digit zcta 0.005163692 0.388821513 5 4 44010 44010 z5 5-digit zcta 0.009404559 0.473260593 6 5 44082 44082 z5 5-digit zcta in tried upload table in ssrs , getting error "no spatial field in table". can me query converts area/perimeter spatial field. what intend data once have it? i suggest read: http://stackoverflow.c...

apologies in advance dumb question.  i have built great little database on sqlserver2008.  now have more users , want restrict rights.  all users access using windows authentication, , seems users can more or less - select, insert, update delete etc.  i suspect dbo, cannot find out.  how find out different windows users allowed database , put restrictions on them?   i missing basic here!  i know roles , whatnot, not see mapping of roles windows users happens. kind regards phil ok - think have this.  it seems no-one has access themselves, (including me) has access through mysterious group windows account our network sa had forgotten about.  he has no idea why account should have been given sa access database, , created database , server , didn't it! active directory oddity guess. so going pick different group, have loads , mysterious 1 broad, , give in group access need.  and set myself separately sa. thanks help. kind r...

hello all, i have sql server express 2012 setup on server. how can schedule job in sql server 2012 express since not have sql server agent?  thanks below links help how schedule backup in sql server express free job scheduling tool sql server express please mark reply answer if solved issue or vote helpful if helped other forum members can benefit it. my technet wiki articles SQL Server  >  SQL Server Express

as per bol surrogate keys generated dbms not derived data in database , significance act primary key. can guids, , identity can considered surrogate keys? what else can considered surrogate keys? ~manu http://sqlwithmanoj.wordpress.com some applications use "key generator", sql code in database, create surrogate keys.  oracle , db2 both have "sequence objects" generating keys.  there few articles can found simulating sequence objects in sql server. when generating fake data use table of numbers or numbers cte generate keys.  suggest total number of methods of generating surrogate keys large -- perhaps infinite -- , subset of ideas. of course doesn't mean ideas ones, limit might limits of imagination. SQL Server  >  Transact-SQL ...

i have simple locationhierarchy table id, parentlocationhierarchyid, name columns. the proc below produces exact output want want create result set can pull datatable or whatever. how do this? adding simple select print command creates result set each row. not want. i imagine using sort of temp table might work, not know how impliment it. thank help earl     alter proc dbo.showhierarchy (  @root int,  @maxlevel int ) as begin  set nocount on  declare @id int, @name varchar(30)  set @name = (select name dbo.locationhierarchy id = @root)     if @@nestlevel<@maxlevel   begin     print cast(@root varchar) + ' - ' + (replicate('-', @@nestlevel * 2) + @name)   end  set @id = (select min(id) dbo.locationhierarchy parentlocationhierarchyid = @root)  while @id not null  begin    exec dbo.showhierarchy @id, @maxl...

i use several wcf services in silverlight 5 app. when making async calls these services windows environment, behaves expected. however, when making same calls macosx environment appears though async service calls not being treated async. 1 of service calls happens in load event of page. on mac when navigating page whole app locks 30 or 40 seconds while service call being executed, , doesn't unlock until callback happens. there 2 issues this: 1) service call simple , there no reason why should take 30-40 seconds reach callback, , 2) it's async, there no reason know of why blocking ui. any ideas? thanks, josh nevermind. misdiagnosis of problem . Silverlight  >  Accessing Web Services with Silverlight ...

i have silverlight application communicates wcf service. when parameter size exceeds 8000 bytes, starts causing errors. example:            servicereference1. service1client sclient  = new mysltest.servicereference1. service1client ();            string s = "..... large string ";            sclient.doworkasync(s); i have googled lot have not come accros solution works. can point me simple sample works larger buffer 8000 bytes ? works fine sizes smaller 8000 bytes. several posts in these forums suggest changing elements in web.config wcf/web services pretty sure has nothing limitation. my servicereferences.clientconfig looks follows (this default vs2008 sp1 generates when adding wcf web service reference): < configuration > < system.servicemodel > < bindings > < basichtt...