Viewing 15 posts - 16,096 through 16,110 (of 19,564 total)
I would expect things security related since it is the security manager.
As for what kinds of questions, that will depend on the interviewer, interviewee, environment, and what is on your...
March 22, 2010 at 1:31 pm
I demonstrated a method to capture that kind of information in order to find out what was causing log files to grow. The same principles can be applied to...
March 22, 2010 at 1:24 pm
HowardW (3/22/2010)
Lookup Row_Number() in BOL:http://msdn.microsoft.com/en-us/library/ms186734.aspx
Combining this with a CTE should get you what you need.
Agreed
If you post some sample data and the expected result, I'm sure someone can post...
March 22, 2010 at 1:21 pm
Nice sample and explanation Dave and Bob.
March 22, 2010 at 1:19 pm
Michael Valentine Jones (3/22/2010)
If it is really a primary key, then you would not use the DROP INDEX statement.You would use
ALTER TABLE tablename DROP CONSTRAINT constraint_name
Good idea to point...
March 22, 2010 at 1:17 pm
sunny.tjk (3/22/2010)
I deleted the foreign key but I'm still not able to delete the primary key. Is it any way connected to the unique keys that I've on 3 columns?
A...
March 22, 2010 at 1:13 pm
GSquared (3/22/2010)
When I was getting the new engagement ring, I joked with some friends, "Oh my God! What will I do if she says, 'no'?" 😀
You would have been...
March 22, 2010 at 1:11 pm
Steve Jones - Editor (3/22/2010)
Have to be close to home as a cranky Steve on the road might not get another "I do" 🙂
I think a Cranky [any person] would...
March 22, 2010 at 1:08 pm
I think we need to be careful here. I would keep the list short. You don't want to have to answer 20 questions about your question just to...
March 22, 2010 at 1:06 pm
Have you tried to install them on a different machine?
Is this a fresh install of 2k8 as well?
March 22, 2010 at 1:02 pm
sunny.tjk (3/22/2010)
An explicit DROP INDEX is not allowed on index 'dbo.PAYMENTS_tmp.PK_Payments_tmp'. It is being...
March 22, 2010 at 12:45 pm
Here is a blog that should prove useful.
http://blogs.technet.com/andrew/archive/2008/03/30/sql-server-2008-best-practice.aspx
March 22, 2010 at 12:43 pm
rkinney-802645 (3/22/2010)
Hi all.Found info on http://msdn. microsoft. com/en-us/ library/ms191545 (SQL.90). aspx .
Thanks,
RKinney
Thanks for posting back.
March 22, 2010 at 12:38 pm
Viewing 15 posts - 16,096 through 16,110 (of 19,564 total)