Sean Lange (6/18/2014)

---

Ed Wagner (6/18/2014)

---

JAZZ Master (6/18/2014)

---

SQLRNNR (6/18/2014)

---

Ed Wagner (6/18/2014)

---

SQLRNNR (6/18/2014)

---

Sean Lange (6/18/2014)

---

whereisSQL? (6/18/2014)

---

Ed Wagner (6/18/2014)

---

JAZZ Master (6/18/2014)

---

Stuart Davies (6/18/2014)

---

With all the food being mentioned, I was...

smtzac (6/18/2014)

---

when I run this query:

SELECT name AS [File Name] , physical_name AS [Physical Name], size/128.0 AS [Total Size in MB],

size/128.0 - CAST(FILEPROPERTY(name, 'SpaceUsed') AS int)/128.0 AS [Available Space In...

Ed Wagner (6/18/2014)

---

SQLRNNR (6/18/2014)

---

Sean Lange (6/18/2014)

---

whereisSQL? (6/18/2014)

---

Ed Wagner (6/18/2014)

---

JAZZ Master (6/18/2014)

---

Stuart Davies (6/18/2014)

---

With all the food being mentioned, I was getting hungry and had to change the...

Sean Lange (6/18/2014)

---

Also make sure you have a GO after your procedure code or the procedure will end up trying to call itself.

Create PROC [dbo].[spAdminFundedDateee]

AS --needed

Begin

...

Sean Lange (6/18/2014)

---

whereisSQL? (6/18/2014)

---

Ed Wagner (6/18/2014)

---

JAZZ Master (6/18/2014)

---

Rice...

Jack Corbett (6/18/2014)

---

SQLRNNR (6/18/2014)

---

Sean Lange (6/18/2014)

---

/RANT ON

Argh!!! Why do some people around here consider me to be their own private consultant. They send me a PM with a...

swaseem345 (6/18/2014)

---

Thank you Luis, I managed to update it but is there a way for me to not put a parameter in the Stored procedure. Because by "Begin" SQL is...

Sean Lange (6/18/2014)

---

/RANT ON

Argh!!! Why do some people around here consider me to be their own private consultant. They send me a PM with a vague description of something and...

One solution is to have your network admin add a dns entry that resolves the name (SD01) to the IP address of SD02 during the failover period.

Hahahaha

No. SQL Server is not dying. I see more and more people shying away from those open source technologies and coming to SQL Server every day. Those platforms...

Try this instead

SELECT REPLACE(REPLACE(Place,')',''),'(','')

FROM names

Ed Wagner (6/18/2014)

---

I know what you mean. I've...

Jack Corbett (6/18/2014)

---

Well that's a pisser. Especially since my answer is using a...

Hema kumar-337490 (6/18/2014)

---

The following scenarios in general I would recommend to reboot the machine.

1.After the SQL Server patches and Service Pack updates.

2.Windows Quarterly Patches or security updates.

3.Any server maintenance tasks.

4.Firmware...

As David and I said, an expression can hide display a column based on the results and/or parameters used.