Viewing 15 posts - 15,841 through 15,855 (of 39,921 total)
Install SQL Server, ignore the warnings, and then install SP1.
June 17, 2011 at 12:19 pm
GilaMonster (6/17/2011)
June 17, 2011 at 11:49 am
checkpoints flush log records to disk, both committed and uncommitted. When the database recovers (in restore or on restart), the redo/undo actions either mark the data files with the changes...
June 17, 2011 at 10:25 am
George,
I used to give Devs only the same access as the application in development. That was mainly because I'd end up with tables like this
Create Table Customer
( CustomerID varchar(100)
...
June 17, 2011 at 10:22 am
You need to mock up a little more DDL. It's still not clear what you're intending.
CDC isn't necessarily what you would use. CDC is for detecting changes, but in general...
June 17, 2011 at 10:08 am
Management Studio Express: http://msdn.microsoft.com/en-us/library/ms365247.aspx
June 17, 2011 at 10:06 am
ksmadhuri (6/16/2011)
thanks for the replies...i tried what Steve Jones had given...i m getting all the data but i need is to get for particular id i need...
June 17, 2011 at 9:23 am
You'd have to give more details, but likely the master table isn't going to slow you down if it's not very large. It will probably live in memory and be...
June 16, 2011 at 7:06 pm
GilaMonster (6/16/2011)
Go watch this:http://channel9.msdn.com/Events/TechEd/NorthAmerica/2011/DPR201
TechEd North America presentation titled "The Architect". Fantastic and so funny in so many places
Downloading now. Bandwidth appears to be tight now and it's unwatchable live. Buffering...
June 16, 2011 at 5:41 pm
Jorge and Gail have given you some good hints. There's not good script that we can give you because the movement will depend on the table structures and what's in...
June 16, 2011 at 1:57 pm
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
Viewing 15 posts - 15,841 through 15,855 (of 39,921 total)