You might be using Scalar Function. It behaves like cursor & degrades performance. So what you have done (adding function query in procedure) is right approach. We can suggest even...

L' Eomot Inversé (12/27/2011)

---

Dev (12/27/2011)

---

So who is / are pulling his sledge...

PaulB-TheOneAndOnly (12/26/2011)

---

erwinluke (12/24/2011)

---

Many ways are present to move or copy a database from one server to another server using SQL server tools. Even so, as my experience the best way...

I have to ask ‘Why you are against Linked Server?’ What’s the harm you see in having it attached in SSMS. If you manage User Access properly it should...

It was not stupid just an oversight. It happens sometimes. Please don't discourage yourself. 🙂

Dev, please, can...

You are limited by hardware resources so whatever we would suggest it would be based on resource availability (and may not be best design).

Keep your C: drive reserved for App...

So who is / are pulling his sledge now? Automatic? 😉

If it's identity column, then yes it should be auto populated. Please crosscheck on Identity column for Employee1...

Then you should go for Dirty Solution i.e. cursor / loop & catch errors for each row.

Determine Whether a Memory Leak Exists

1. Launch the Task Manager by pressing "Ctrl+Alt+Del" simultaneously.

2. Check the memory usage of SQL Server. To check the memory usage, click the...

It may sound silly but is downtime of Server acceptable? Is it DEV / Demo / Test Server?

In general it’s not a good idea. If you provide us more details...

I don't see any issue in following query.

INSERT INTO EMPLOYEES1 (LASTNAME, FIRSTNAME)

SELECT LASTNAME, FIRSTNAME

FROM

(SELECT EMPLOYEEID, LASTNAME, FIRSTNAME

FROM EMPLOYEES

WHERE EMPLOYEEID < 5

) ZXTABX1

Do you get any...

Can you provide us more information? What’s the disk sizes & available space on each disk? Is it RAID (type)? How big your database (data & log file) is? On...

Don’t worry that’s SPAM. I reported it yesterday but it seems SSC admin staff is vacation so cleanup is delayed.

Example:

USE AdventureWorks2008R2;

DENY SELECT ON OBJECT::Person.Address TO RosaQdM;

GO

For More: http://msdn.microsoft.com/en-us/library/ms173724.aspx