Viewing 15 posts - 361 through 375 (of 1,179 total)
Check the firewall settings and verify SQL Server is able to allow connection.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 31, 2014 at 1:16 am
Refer following article:
http://www.sqlservercentral.com/articles/FCI/92196/
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 31, 2014 at 12:08 am
Nowhere in the question it is mention that login 'king_login' is part of sysadmin fixed server role?
Neither in the script login 'king_login' had been added to the fixed server...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 31, 2014 at 12:05 am
Grant Fritchey (3/28/2014)
free_mascot (3/28/2014)
Check the option of Extended event.
Sorry? What?
Do you mean set up an extended event session to capture sql batches and rpc calls? That's a good idea. I'm...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 30, 2014 at 10:58 pm
Check the option of Extended event.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 28, 2014 at 5:33 am
You can also use:
select * from sys.columns where max_length = -1
/*Where -1 = Column data type is varchar(max), nvarchar(max), varbinary(max), or xml. */
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 28, 2014 at 2:57 am
Pl. refer following blog which might help you:
http://www.sqlservercentral.com/Forums/Topic1554747-2799-1.aspx
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 28, 2014 at 2:33 am
Can you check design on the other subscriber? Do you find FK on ther 10 subscriber too?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 28, 2014 at 12:38 am
Bit tricky question. Overlooked word "hardened".
Now if the correct answer is "Login is not created" than second correct answer "If the login is created the password policy will be...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 28, 2014 at 12:03 am
Yes, I missed extended events. Thank you Grant.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 27, 2014 at 5:16 am
Pl. refer following article for further detail:
http://www.sqlservercentral.com/articles/FCI/92196/
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 27, 2014 at 5:07 am
Me too agree with Steve, Brent and everyone on this.
But DBA should keep in mind that this is not the place for falling and riseing approach. I do agree...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 27, 2014 at 4:02 am
Refer the following link for detail:
http://technet.microsoft.com/en-us/library/cc708332(v=ws.10).aspx
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 27, 2014 at 3:37 am
Refer following link:
http://stackoverflow.com/questions/2077807/sql-query-to-return-differences-between-two-tables
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 27, 2014 at 2:57 am
Again are you going to insert data to that table?
howmuch rows and size?
Do you need the space badly?
What if you do not shrink?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 27, 2014 at 1:16 am
Viewing 15 posts - 361 through 375 (of 1,179 total)