I suppose for a rough and ready answer, you could query the plan cache for statements that don't contain "@". You'd have to eyeball the results to make sure...

I'm not sure whether there's a question there, but I still don't recommend doing it like that. Yes, if a new table is created then you have to create...

Thanks for the link, but if you don't make it clickable, people aren't going to bother reading it. Anyway, why not create 100 staging tables - one for each...

If there is no linked server, how are you doing the transfer? Why does this need to be dynamic - does the structure of the source table change on...

Work out how many days there are from the end of the financial year to the end of the calendar year. Now add that number of days to each...

AlianaRivera887 (6/23/2016)

---

Hello,

No sure if this will help, but in SQL job. In the Configuration tab of the SSIS package step, there is a parameters tab that has a field called...

Clearly not, especially given your unwillingness to provide the necessary details.

John

Foreign keys between tables and SCHEMABINDING option in view definitions are two reasons why tables and views might not be able to be dropped. Alternatively, perhaps you don't have...

Is it possible that it's failing because the LooksAlive and IsAlive checks can't connect? Please will you post the errorlog for when it doesn't start properly? The SQL...

Yes, you can, but you need to restore the full backup first, so I suspect that would defeat the object. You might consider putting your HISTORY table in a...

No, I think you explained it quite well. But you don't need a cursor to do this. Does what santiagoc93 posted not work for you?

John

I notice you're back to 1433. Does it work like that, or does it fail now whatever you do? Since you're on a cluster, is the NETBIOS name...

My first reaction is don't put it anywhere, unless you're comfortable with the possibility of incorrect data. If you are, I'd go for Statement 1, where it's nice and...

Please will you post the contents of the errorlog, then? You can redact the server name and any other details that you don't want the rest of the world...

From what you quote from the event log, it sounds as if it's only the Fulltext service that isn't starting. Are you saying SQL Server isn't starting as well?...