First please read the article in my signature about posting these types of questions to the forum. After you do that I could make sure that the answer is correct....

To verify your instance name open SQL Server Configuration Manager -> SQL Server Services (left pane) -> Double click your SQL Server service -> Click on the Service tab and...

rj529 (2/5/2014)

1.perticular user is only created for databses only?

2.perticular user is only created for stored procedures nad alterd also?

3.perticular user is only created for tables only?

4.particular user access for one...

I agree with Lowell's approach

Please read the first article in my signature and post the missing information. We need a create table statement, some sample data and the expected outcome. Thanks

Hi David welcome to the forums. Please read the article in my signature about posting questions to the forum this will help us in solving your question. Without knowledge of...

I was planning on doing some research on this topic anyway, so I will take this one.

I am currently using Ola Hallengren's[/url] backup scripts for my backups and a custom SSIS package that I created to perform my restores and DBCC CHECKDB. The package is nothing...

As Grant pointed out you really need to perform all of the actions together to have an idea of when the corruption occurred (what day). I always take my backups...

If you are altering your table structures you shouldn't have to mark them for recompile. Here is a quote from BOL article on ALTER TABLE:

If there are any execution...

You get one freebie without create table statements and sample data :-D. Please read the article that I mentioned and add the necessary information to the post and someone will...

Agree. I...

Save yourself some time and just run dbcc freeproccache (just kidding), but what is the reason for the script? Why do you want to have every store procedure, trigger, etc....

Looks like connection pooling to me. Read the following article: http://msdn.microsoft.com/en-us/library/8xx3tyca.aspx

Welcome to the forum and congrats on trying to improve you T-SQL coding ability. Please read the article in my signature and repost you question with the create table statements...