If you're using a DATETIME, you can use the DATEPART function to get the hour and group on the value for the hour based on a 24 hour clock.

DATEPART(hh, GETDATE())

You...

How are you determining which record is the "correct" record to return for the duplicates? For instance, how do you know you want the LA Shawn and not the...

It is known that SQL Server will try to resolve anything with an "sp_" prefix as a system stored procedure first and if it cannot be resolved it will try...

The issue is, you are specifying the GO batch separator so if you encounter an error in one batch, the subsequent batches will still execute.

If you encounter an error you...

How are you storing the images? Is the binary data being stored inside a table or are you storing references to the images?

I noticed this was happening on one of my SQL instances.

In order to fix the problem I followed these steps:

1) right click Data Collection and select Disable Data Collection (this...

Firewall is disabled so I don't think that is a factor.

Thank you for your assistance.

John

Yeah same, but I noticed if I fully qualify the instance name it will go green.

So fully qualified shows green and if I just put the hostname it shows red...

Yeah I thought it might be something along those lines so I shut down SSMS and re-opened it. I was able to watch it poll each registered server and...

BCP will pull data from a file. This method is to pull data from an existing table to another table.

Could also use SQLBulkCopy .net library (or SSIS).

I am doing something similar. We need to get data from one server to the other with minimal impact to the developers deployment process and minimal bandwidth. What...

Yes, "not for replication" was included in the generated script. I commented it out and now it is not happening.

I found this link[/url] with a bit of information on...

I understand. I will see if I can get a mocked up version of the code that accurately represents what's actually going on.

thank you

I don't think I'm allowed to post the code.

I really just want to know if this locking scenario is something that should be unexpected. Based on everything I've read...

Thank you!!