When I run this;

EXEC sp_executesql...

There are two types or databases in our systems; parent and child. This script is supposed to go through the parent databases first (as outer loop), pick up child db...

SET @sql='SELECT @aId, @dId, @dStatusId, d.DateCreated,...

autoexcrement (2/25/2014)

---

I may be stupid and just missing something obvious, but I don't see where you're storing dates at all. You're only storing time and day of the week. So...

Erland Sommarskog (2/5/2014)

---

So these 10 databases have the same set of tables, with each database serving a specific client?

I am not sure that I think it is a wise move...

The actual goal is to reduce the total number of databases. Each client has their own parent dbs + one db for each project. Schemas are identical, and one user...

Great, Thanks.

Found it.

SELECT

substring(substring(dbconnection,CHARINDEX('Database=',dbconnection)+9, LEN(dbconnection)),1,CHARINDEX(';',substring(dbconnection,CHARINDEX('Database=',dbconnection)+9, LEN(dbconnection)))-1)

FROM Connections

Thanks,

Kuzey

The app design can change to...

Budget restrictions.

The number of databases is not as important as their size and memory or CPU utilization. I would not be worried about having thousands of databases if the SQL...

Message taken 🙂

Thanks to you all.

At my first full-time job at a cell phone/network company gave me a cell phone in 1994. That was my first on-call. The excitement fade away very quickly realizing ,...

and some companies know some people are not motivated by a %3 increase, but can be motivated by more intimate incentives.

http://www.bbc.co.uk/news/world-europe-13454160

I did not say "IS" but "CLOSE" to point out similarities, not differences. I do think, in general, employers get too much benefit of their employees. Employees stay because they...

We, employees, can't even...