Yes. There is a problem.

User defined functions does not allow dynamic execution of SQL.

I think you will have to use CLR or work around with other options.

Regards,

From what i understand, you want to see a prompt in the main page and it should ask you to select the report you want to see.

You will select Report1...

I believe you will have this feature with VS 2005 aswell.

If you want to format the background color based on the condition, right click on the item you want to...

Paresh Prajapati (12/25/2008)

---

I want to do following :

Use can not alter or create table from UI designing.

They can alter/create table from running query in query analyzer but not directly from...

Job is the task(s)/work that you want to do.

Schedule is when you want that to be done. I am sure you know all this but...

BOL has enough information for you...

Someone in the forum can be of help to you if they can see the code here.

Regards,

Sam.

One way of doing this is to use dynamic sql in your stored procedure.

The following code may help you to start with.

DECLARE @Table_Name varchar(40)

DECLARE @sql nvarchar(max)

SET @Table_Name =...

Thankyou. I just realized it.

It's all about...

Included columns are only for non clustered indexes but not for clustered index, i believe.

There are three database roles in msdb database.

SQLAgentUser

SQLAgentReader

SQLAgentOperator.

A user if he is not a sysadmin must be a member of either of the roles under msdb. SQLAgentOperator role gives users...

No.

I thinks DMV's get refreshed when either the service or server gets restarted.

Thankyou Jonathan!

May be i got close on this one.

I executed this query multiple times select * from Person.Address where ModifiedDate = '01/01/2008' (there is no index on ModifiedDate)....

Self Join,

Inner Join,

Left Outer Join,

Right Outer Join,

Cross Join,

Full Outer Join.

You should find lot of articles either on this site or Books online which explains with useful examples.

Here is a sample:

I am wondering how you can write a trigger that would be fired before inserting/updating rows into a table.

If i am not wrong a trigger will fire either after or...

it's a windows 2003 server enterprise OS and sql server 2005 enterprise edition.

I do not have access to connect with sa login.

Thankx