XCopy still exists on Win2008, thankfully although slated to be deprecated. Still need to check on 2012 but my feeling is that it is still there

An alternative is Robocopy.

Are you trying to access SQL from the internet in which case are you using the correct IP address? Try http://www.whatismyip.com/ or similar from the box in question....

Can you provide the table definitons. And any data if poss

To turn into a stored procedure then its simple:

create proc sp_GetEventOccurances @SelectedYearchar(4)

as

begin

Declare@SqlCmdvarchar(8000)

,@Columnsvarchar(8000)

,@min_Datedate

,@max_Datedate;

-- Work out the Data range

select@min_Date = min( Event_Start )

,@max_Date = max...

Although not coded in an efficent way the following might help...

CREATE PROC dbo.MyProcedure

AS

declare @token1 int

,@token2 int

...

A slight alternative that might be easier to understand:

Sample data:

If Object_Id('TempDB..#Editions', 'U') Is Not Null

Drop Table #Editions

Create Table #Editions

(

Edition_ID Int Primary Key Clustered,

Edition_Year int,

Edition_Start date ,

Edition_Finish date

)

Set Dateformat DMY

Insert...

Interesting.

Or old school:

select distinct Number from master.dbo.spt_values where number between 0 and 1000

Another one I have seen is:

;With CTE ( [Number] ) as (

select Number =...

Travis (4/8/2013)

---

Steve JP (4/8/2013)

---

President Lincoln said:

“You can please some of the people all of the time, you can please all of the people some of the time, but...

If someone cant take any comment about their work then they and not the person passing comment ought to be on soft skill training. I have worked with someone who...

Get into a habit of leaving the "on primary" off all your code. When the code gets released the DBA can decide if it is appropriate where the objects (tables,...

Then what is the name of the instance...

Where can you connect from?

locally on the server but not from a remote machhine then it wold indicate that either a fire wall (or a router with an access control...

If you navigate to the folder or to the equilivant:

C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log

You should see a list of errorlog files. Open the the most recent file and see what port...

Is the SQL Browser running on the server?

Go to the command prompt and run:

tracert <servername>

What is the response? It should list the IP address os the sever and none of...

MSSQL_NOOB (3/28/2013)

---

.............. [ed]

Let's say I have a

full backup at 12:00am.

log backup at 12:30am

log backup at 1:00am.

Will my 1:00am log backup have data from 12:00am - 1:00am...