Viewing 15 posts - 15,901 through 15,915 (of 39,970 total)
Make the change, but click the "script" button in SSMS before saving. It's at the top. Then post that
June 16, 2011 at 1:18 pm
It might, it depends on how security is set up. However if you have the service account for your application logging in, that isn't impersonating the user. Each user would...
June 16, 2011 at 12:53 pm
I'm not sure you have enough data in there to more accurately show, but basically you have one filegroup, so the data is split among the files. If you insert...
June 16, 2011 at 11:51 am
GilaMonster (6/16/2011)
Why are you surprised by the rejection reason? Speakers are allowed max 2 sessions, I'm doing a pre-con with Grant and a spotlight, so 'exceeded max allowable sessions' is...
June 16, 2011 at 10:59 am
Why is the Asus better? Not arguing, but curious. I've debated playing with an Android tablet as well.
June 16, 2011 at 10:37 am
I'd agree with Elliot, this is an OS/NTFS error with security of some sort. The checkpoint file is being written when you go to standby during a restore, and needs...
June 16, 2011 at 9:14 am
SQL Server Express is a program that has to run on your machine as a service. You download the installer and then it will set up a new service and...
June 16, 2011 at 9:12 am
GilaMonster (6/16/2011)
June 16, 2011 at 8:53 am
Fal (6/16/2011)
...
So I start undressing. As luck would have it the spider is dislodged by my satchel...
June 16, 2011 at 8:50 am
Trey Staker (6/15/2011)
Steve Jones - SSC Editor (6/15/2011)
...There are 105 different people that have posted here, just under a hundred with only 1 post.
105 different people with more than 1...
June 16, 2011 at 8:47 am
Typo fixed, and glad you liked the question. It's a new feature, and I don't know anyone using this personally, but there are a few case studies out there for...
June 16, 2011 at 8:46 am
Here's a good summary as well: http://msdn.microsoft.com/en-us/library/dd535534%28SQL.100%29.aspx
If you explain what you don't understand, we can help you, but your question is so general right now that a reference is the...
June 16, 2011 at 8:44 am
Sean is correct. SQL Server only has the information about which account logs into it. If the application proxies other users, then you would need to modify that application to...
June 16, 2011 at 8:43 am
Sean's idea of distinct is good, but you also shouldn't write joins like that. It's easy to implement a cross join somewhere.
Move to an ANSI standard, like this:
select DISTINCT
...
June 16, 2011 at 8:40 am
OK, here are the current top posters:
SQLRNNR - 2567
GilaMonster - 1957
Lynn Pettis - 1775
Alvin Ramard - 1745
Steve Jones - SSC Editor - 1434
Grant Fritchey - 1427
Jeff Moden - 1258
GSquared -...
June 15, 2011 at 2:42 pm
Viewing 15 posts - 15,901 through 15,915 (of 39,970 total)