Viewing 15 posts - 631 through 645 (of 4,477 total)
can you tell me if ssrs reports translate the dates for us? if so, how do you accomplish this goal?
You can set it at the report level or the...
April 28, 2019 at 7:03 pm
Adding another - Is the protocol the alias is setup for enabled?
Sue
April 25, 2019 at 4:17 pm
Sorry about that - I made a bad assumption. You'd still be looking at all the same things Thom pointed out. You could also try testing a totally basic report...
April 24, 2019 at 6:34 pm
Did you check the SQL Server error logs on the instances for any related errors? Do all of the instances have connect permissions? Is the firewall port open (default of...
April 24, 2019 at 6:20 pm
Need some more information as Thom indicated. Take a look at the view ExecutionLog3 as this can help you figure out where the time is being spent on generating the...
April 24, 2019 at 6:14 pm
It's still a pretty good tool - especially for free. Not sure why it became free this year or if that's going to last since Quest bought ApexSQL just last...
April 23, 2019 at 10:26 pm
That is weird - when I click on mine, it goes to the correct article/link. There was something in the newsletter last week that took me to the Data Compression...
April 22, 2019 at 9:44 pm
Smart quotes are only good for testing find and replace functionality.
Sue
April 22, 2019 at 8:54 pm
You need to do a forced failover. The steps to failover and then switch the roles back are covered in the Forced Manual Failover documentation:
April 22, 2019 at 8:00 pm
Keep looking 🙂 There are actually six different queries in there for different connectivity or login issues. I'd look at all of them just with it being such a vague...
April 22, 2019 at 6:08 pm
It would depend on why they think its a connectivity issue. Sometimes people just say things like that for no reason really other than they are just guessing. You could...
April 22, 2019 at 5:22 pm
If you don't have a primary key on a table, you can't publish it with transactional replication. You could use merge or snapshot replication which don't require a primary key.
The...
April 22, 2019 at 1:48 am
Try using DATALENGTH instead:
SELECT DATALENGTH(TRIM(' SSMS '))
SELECT DATALENGTH(LTRIM(' SSMS '))
SELECT DATALENGTH(RTRIM('... April 22, 2019 at 1:25 am
Ugly but I think you can put an Execute SQL task between the data flows and execute WAITFOR TIME.
Sue
April 22, 2019 at 1:15 am
SQL Server allows the use of = notation for a column alias. So you have an alias, not a Boolean expression. The column alias is A so it would be...
April 22, 2019 at 1:10 am
Viewing 15 posts - 631 through 645 (of 4,477 total)