Viewing 15 posts - 4,651 through 4,665 (of 9,712 total)
Gianluca Sartori (2/28/2012)
February 28, 2012 at 9:27 am
Lynn Pettis (2/28/2012)
GilaMonster (2/28/2012)
satishm94 (2/28/2012)
6)When updation & insertion is going on back job has to wait or not?Huh?
Basically, do INSERTs and UPDATEs block a backup from running.
Depends. How poorly...
February 28, 2012 at 9:25 am
Is it really a blank (as in spaces) or NULL values? There is a difference.
Also, what is the source column data type and what is the destination column data type?
February 28, 2012 at 8:14 am
satishm94 (2/27/2012)
when u automate a backup strategy which one u choose in ur organization, and why??
I don't automate backup strategies. I automate backups for a recovery strategy. And which one...
February 28, 2012 at 8:04 am
If you want to share scripts, there are places to do that outside the forum itself (http://www.sqlservercentral.com/Scripts/%5B/url%5D).
And Steve loves showcasing new scripts in the newsletter.
February 28, 2012 at 8:02 am
The easiest way?
I'd say restore the database to the other server and delete the unneeded tables. Which runs into problems if you delete FK related tables in the wrong...
February 28, 2012 at 8:00 am
Not that it should break replication unless you're connecting the new table to an existing "article" table, but ...
Which side of replication are you intending to add the table?
February 28, 2012 at 7:56 am
Koen Verbeeck (2/28/2012)
GilaMonster (2/28/2012)
satishm94 (2/28/2012)
4)What is proxy server? Why do u need it?No such thing as a proxy server in SQL Server
Maybe proxy accounts in SQL Agent?
No. Based on the...
February 28, 2012 at 7:52 am
LutzM (2/27/2012)
Koen Verbeeck (2/27/2012)
This one obviously is (on another site):
...
I wonder how he managed to get so many questions. If he doesn't know any answer after 5 questions, I...
February 27, 2012 at 11:06 am
Thank you for posting that.
Anti-Virus software kills things every time. I have seen more problems caused by that... Sorry I didn't think about it in your situation.
February 27, 2012 at 7:01 am
Which node has the newer network driver? The slow one or the fast one?
And what are your network card configurations for both servers?
February 27, 2012 at 6:16 am
Congrats on the new job, Lynn. I love Colorado Springs. If I get a chance to move to Colorado, that's the city I want to live in.
As close to the...
February 27, 2012 at 5:22 am
LutzM (2/25/2012)
Jeff Moden (2/25/2012)
Returning to the original subject of this thread, I can now say I've seen just about everything on this fine forum.http://www.sqlservercentral.com/Forums/Topic1257783-391-1.aspx
<shudder>
It becomes rather scary when seen in...
February 27, 2012 at 5:19 am
CELKO (2/24/2012)
This is an environment that I INHERITED. I DID NOT BUILD THIS. This is based on a production environment, and I have limited leeway as to...
February 27, 2012 at 5:14 am
I've never actually run into the problem that Gail describes. I was just throwing out a W.A.G. as to what she could have meant. I'm sure she'll reply with more...
February 24, 2012 at 12:40 pm
Viewing 15 posts - 4,651 through 4,665 (of 9,712 total)