Viewing 15 posts - 9,481 through 9,495 (of 9,720 total)
The short answer is "You can't".
Standard only installs client tools on a PC / Laptop. You need Developer version (or Express) to run a server instance on your laptop. Workgroup might...
August 23, 2007 at 12:15 pm
It would seem to me, given the number of columns he's accessing, that he probably has an equivalantly large row/recordset being returned to the view. In that case, an indexed...
August 23, 2007 at 11:21 am
Tracey,
Load is going to be high on Raid 1. Higher for writing than for reading, because the disks are essentially making two copies of every transaction on the mirror. Colin...
August 23, 2007 at 10:44 am
Are you looking under the Database Engine or did you actually connect via Object Explorer to the Integration Services object?
August 23, 2007 at 4:13 am
Tracey,
No reason you can't do this in SQL 2000 that I'm aware of. I just added a file to the TempDB on my local PC version of the database via...
August 22, 2007 at 8:35 am
Tracey,
Look back at the code Colin posted. Just change the FileName stuff (where it currently points to the D: drive) to your R: drive, path and new filename. You'll have...
August 21, 2007 at 7:15 am
Thanks, Steve.
I know where to find a lot of stuff on the toolbars and menus, but I don't have either of them memorized and sometimes depend on the tooltips...
August 21, 2007 at 6:56 am
Files are objects that reside in FileGroups (think of it like individual sheets of paper in a manilla folder. The folder is the file group and the sheets of paper...
August 20, 2007 at 12:21 pm
I'd recommend a side-by-side. This way you can test everything as you move it and if the move doesn't work, it's a work of moments to turn the old database...
August 20, 2007 at 12:13 pm
Named Pipes is not strictly necessary for SQL Server 2005 to run. Unless, of course, you don't have any other protocols set up.
Also, sometimes weird errors happen when you don't...
August 20, 2007 at 12:11 pm
I agree with Jack and Ninja. When I need to restore a table (or even part of a table) that has been deleted, but not mess anything else up, I usually...
August 20, 2007 at 12:09 pm
James, I think your advice is a little bit off. Once the FULL backup is restored, Subu only has to restore the most recent Differential backup and then all the...
August 20, 2007 at 12:05 pm
Chris,
I don't think this guy is being rude so much as he's being confused. After all, the interview process is over and someone else has been hired. Depending on what...
August 20, 2007 at 7:20 am
But only working with agencies that are reliable and polite is not the same thing as being beligerent or rude to a recruiter or potential employer. I'm sure, Matt, that you...
August 20, 2007 at 4:06 am
For MCTS, yes, there is only one test and it is the above test (see http://www.microsoft.com/learning/mcp/mcts/sql/default.mspx for more details).
Unfortunately, the MCTS is like the original MCP. It's not worth...
August 17, 2007 at 3:56 am
Viewing 15 posts - 9,481 through 9,495 (of 9,720 total)