As the last post showed, @@ServerName gets you the name of the server, DB_NAME() gets you the current database. If you pass it a database ID, it will get any...

There's nothing all that special about a view. It's just a query that sort of behaves like it was a table. If you need to move data out of the...

The index is bigger. That means more disk space will be needed to maintain. It's possible that it will have more levels because of the extra size which will add...

pandeharsh (3/31/2009)

---

Hi,

Suppose i write a general proc like this.

Create proc Example

@empid int,

@Mode varchar (1),

@fname varchar (100),

@lname varchar(100)

As

If (@Mode='S'

Begin

Select fname,lname from emp where empid=@empid

End

If (@Mode='I'

Begin

Insert into...

If the procedures are still in the cache you can query sys.dm_exec_query_stats to see exactly how long the procedure ran, how many resources it used, etc. You can even combine...

You may need to filter the data. Include a WHERE clause to limit the amount of information you're getting back.

I guess the question is, do you want grow your own monitors or do you want to go & purchase some of the more sophisticated monitors?

If you want to grow...

That's all right.

Pick up a copy of SQL Express. It's free and you can learn most of what you need there. When you want to expand into mirroring and...

iqtedar (3/30/2009)

---

thanks..i understand that it cannot be used as a production server...i was just wondering if someone has the files for dev edition can i just copy and install..making sure...

Excellent. Thanks for letting us know it worked.

You forgot quickly....

I agree with Paul. Do a FULL SCAN when you update the statistics.

Oh man, thousands... network connectivity, security, service shut down, changes to connection strings... Those are just the easy ones. It could be client configuration changes... It's really hard to say.

Actually I would have expected that to be a problem in 2000 as well. All 2000 is doing is an implicit convert, that you should get in 2005 as well....

Looks like you either have a connection error, or possibly your DTC process is down:

Microsoft.CommerceServer.Runtime.CommerceException: [highlight=#ffff11]Could not connect to datasource [/highlight]---> System.Runtime.InteropServices.COMException (0x8004D00A): [highlight=#ffff11]New transaction cannot enlist in the specified...