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?...

Steve

Try something like this, but bear in mind:

(1) I don't recommend you use this in your application - just for the stopgap period

(2) I haven't included any WHERE clause logic,...

No, that's for client applications on the server. Go to SQL Server Network Configuration -> Protocols...

Does db_name exist on the remote server? Does table_name exist in the dbo schema in db_name? What happens if you go to the remote server and run the...

Ragu

Care to post the query, please? I'm guessing it's got a syntax error or something else that prevents it from compiling. Do you have direct access to the...