Dammit - wonder if there's any replacement tool for BPA.

Sorry to resurrect this thread, has 2014 BPA been released? Can't find it anywhere.

Hi Gail, just by looking at the service in Task Manager it's obvious it is idle.

Any ideas?

Your last reply confused me a bit but I think you meant you can't get the affected DB in offline mode?

ONLY if the above is true AND you intend to...

open your Windows Resource Monitor to view which process is resource intensive:

From the Run box (windows key+R), enter

C:\Windows\System32\resmon.exe

http://www.sqlservercentral.com/articles/Reporting+Services/106306/

Run the following to determine who and how many connections are open against which DB's

SELECT

...

Just because SSMS takes long to open doesn't mean SQL is the cause.

Your CPU utilization could be caused by any other process on your server, and you'll need to...

yes.

http://msdn.microsoft.com/en-us/library/ms143506.aspx

Koen Verbeeck (1/28/2014)

---

You mean assigning a literal value to a datetime variable?

DECLARE @datetime DATETIME;

SET @datetime = '2014-01-28T08:26:14';

SELECT @datetime;

philosophaie (1/27/2014)

---

And correct...

Make use of parameters for a start and end date, or a date as a single value, depending on your requirements.

Add a parameter as Date/Time Type, Set the Default Value...

Well, did you

?

create procedure _sp_importexceldata

(@Source varchar(1000)

...

Are you referring to "myhost" as the SQL Cluster Virtual Name or the local active node?

Use the SQL cluster name instead of the node name or...

Was there a question?