Inside those views are they maybe referencing things with schema specified, ie SELECT <columns> FROM dbo.TABLE in the views in both schemas?

The general approach we use is to have some kind of script that will check for your file and wait a certain amount of time for a file with a...

A network admin shouldn't be telling you who you can or cannot create databases for, that is by definition your job as a DBA.

Don't bother trying to fight with a power hungry network admin. Make it known immediately to your supervisor that you are unable to do your job in an effective...

The logic shouldn't be too complicated add your normal filter in the where clause for the start and end dates which it sounds like you already have then add another...

Wait do you mean this is an instance of SQL Server installed on your personal PC that you are trying to run this against?

My guess would be that the network...

I tend to just let the system run and do it's thing, when a necessary change becomes required or something catastrophically breaks then it's time to give an accurate(usually long)...

Doom

Are you sure that's the value that's actually throwing the error?

Eric M Russell (12/1/2016)

---

Other than something like pushing a deployment outside the formal change control process or granting someone elevated permissions, has anyone here ever been asked to compromise their...

In SQL Server functions always return some kind of value, whether that's a single value or table, there's isn't a concept of void functions in SQL Server that just do...

Well you can always look at who has open sessions on the server and close any that look like they don't belong that would remove the temp table if you...

Pelt

Steve Jones - SSC Editor (11/29/2016)

---

ZZartin (11/29/2016)

---

What about cases where you don't necessarily want to sync up the tables exactly, there's advantages to having a simple make tables match kind...

Steve Jones - SSC Editor (11/29/2016)

---

Nelson Petersen (11/29/2016)

---

No need to specify all the columns when you only want to change one of them:

create table test9 (c1 number, c2 number, c3...