Last one from me!

Managed to fix my issue (just couldn't give up without understanding what was causing it).

Came across this article: http://stackoverflow.com/questions/1473315/the-select-permission-was-denied-on-the-object-sysobjects-database-mssqlsyst

which gave me the idea to check...

Just in case someone finds this when troubleshooting the same issue:

Decided to upgrade my"fresh" serve and install CU13 => no issues

It seems that problem is related to the server itself,...

Update:

At the end i decided to start from the scratch and created solution on SQL Server 2008 R2 with CU9 and it is working. I followed the same procedure for...

All objects, including indexes, are created on file groups. Each file group consists of one or more files.

These files could be primary and secondary. (Talking about data files)

If a file...

Start Profiler

Open New Trace

On “Event Selection” tab leave selected

- Stored Procedure/RPC completed

- TSQL/SQL: BatchCompleted

Or anything else you are interested in monitoring

(I would probably initially leave only these two and unselect...

Check this:

http://www.sqlservercentral.com/Forums/Topic1101430-392-1.aspx

Thank you 🙂

Hi Gail,

Any thoughts about pro et contra for both solutions?

Detach/attach seemed more ‘natural’ to me, but would like to understand why you advised different?

Believe that there was a reason.

Respect your...

That requires downtime.

1.Detach database

2.Move the file

3.Attach database, make sure to specify the new path for the secondary file.

Can do it from SSMS or through scripts.

Check BOL for sp_attach_db, sp_detach_db

Your question is a bit confusing...

WHERE should be at the end.

If this is not what you had, please move it to the end (after join between s and x) and...

Hi again 🙂

I could see a few possible problems here:

-Absent student does not exist in table Students (so inner join eliminates it)

(However, that would mean that you do not...

Hi Ashok,

It is almost impossible to help you without more information.

Based on what you described, I believe it is Windows permissions issue.

Could you please:

- write where from you are...

I believe that it is related to the permissions of the folder where the file is.

Check permissions (security) on the c:\ask folder or the file itself.

You didn't say how/where you...

Hey, sorry if it sounded offensive - actually wasn't commenting your post.

When I was reading the original post I realized that it's not really simple as it seemed and that...

It is clear :-), but it's not that easy.

Here is the example of the code:

declare @d datetime --input parameter for the procedure

--set @d='2011-05-09'

declare @StartDate datetime --first day of a...