Viewing 15 posts - 631 through 645 (of 1,999 total)
Me: All the stuff no one knows about until they stop doing it. 🙂
I took a week off - everything broke, they didn't know I was cleaning up "developer...
November 27, 2019 at 9:24 am
Blimey Jeff, you seem quite agitated on this one 🙂 good to see some passion
At my company we have a monthly team meeting (about 30 of us) where we do...
November 27, 2019 at 9:21 am
so either sp_addsubsciption hasn't run (I seriously doubt that)
This sounds like a permission issue, but i'm struggling with your English a little
first steps, can you put a tracer token through?...
November 26, 2019 at 3:49 pm
Welcome to the data equivalent of "Ripley's Believe It or Not". 😀
I think of it more like "stranger things" , but I still get visions of aliens bursting out...
November 26, 2019 at 3:36 pm
If it's a SAN then you might have the same problem that we had with Amazon
depends on your configuration
our connectivity was shared over a network connection which was also shared...
November 26, 2019 at 3:16 pm
chris is correct
this is complex (mostly on the fact that we don't know your environment)
normally we see bloat in the log file (which is easy to fix)
but bloat in data...
November 26, 2019 at 12:35 pm
easy - register all of your servers in management studio as a group (it will appear with a pink bar at the bottom of the screen)
click on the group and...
November 26, 2019 at 12:30 pm
I'm not entirely convinced that i'm answering the right question since your English is a little broken (nothing wrong in that, it's my 3rd language)
if max mem is set to...
November 26, 2019 at 12:25 pm
Sp_readrequest runs constantly, so it will show as a long running query - my vague understanding is that it uses the service broker to wait for a mail and then...
November 26, 2019 at 12:13 pm
My go-to steps for those types of errors are to try ping-ing the server you are connecting to from the machine that cannot connect to make sure it can...
November 26, 2019 at 8:49 am
OK let me in on the alliteration joke
November 26, 2019 at 8:40 am
ok - this is only a guess
Via powershell, you might be using a different protocol (and hence a different port number) - the username and password has nothing to do...
November 25, 2019 at 4:46 pm
if you can connect via powershell, but live cannot connect - 100% firewall, DNS or port issue
November 25, 2019 at 2:07 pm
rvadim is correct
just take the single quotes out of the query. - however if you have stored this as varchar (which is madness) thenyou need to use convert or cast...
November 25, 2019 at 10:34 am
we're using Stretch - easy to configure and just silently puts your old records in the cloud, but allows you to query it like it was one table - there...
November 25, 2019 at 9:33 am
Viewing 15 posts - 631 through 645 (of 1,999 total)