Viewing 15 posts - 1,936 through 1,950 (of 2,007 total)
if you want to ring fence a group of servers use a dedicated product
I didn’t assume group of servers. I just assume one server.
October 12, 2011 at 7:52 am
this is for a client, and they put the cluster into production before doing any testing of the fail over
Didn’t you try to explain them the consequences of this BAD...
October 12, 2011 at 1:38 am
I always disable windows firewall on corporate domain computers
Considering the security, enabling few ports (adding exceptions) would be a good idea.
October 12, 2011 at 1:35 am
It’s a known behavior on Vista.
SQL Server installs with the BUILTIN\Administrators group as the default system administration group. By default, users on Windows Vista that are members of the...
October 11, 2011 at 7:56 am
Did you install SQL Server with same user account 'Boopathi-PC\Marimuthu'? If not, try with the user account you used for installation.
October 11, 2011 at 7:48 am
A small example might be useful.
Few users can CREATE SPs in DEV environment. They are Developers. So you have a group of resources with set of permissions for them...
October 11, 2011 at 6:44 am
They are not DBAs but if there is a need, they have to create/restore databases.
It’s too much risk. It may be fine on DEV environment but not on...
October 11, 2011 at 6:18 am
That shouldn't horrify you. In most places you can download reports to excel, etc etc.
Well, I will say it should. Pulling data in reports is not that dangerous than...
October 11, 2011 at 6:14 am
Does your stored procedure return what you are looking for? If yes, then it’s an issue that needs to be solved by SSRS guy (I am not the one ;-)).
Else...
October 11, 2011 at 5:59 am
If the database schema is same in PROD and QA / DEV environment, you may pull some data back from PROD (subject to legal issues) to DEV environment.
If this is...
October 11, 2011 at 5:50 am
I believe ‘;’ is an ANSI SQL statement terminator which you can use with other RDBMS as well. The same is not true with ‘GO’ as its Microsoft’s own implementation...
October 11, 2011 at 5:23 am
I don’t think it’s allowed. You may pull tables (and views, not sure) only.
October 11, 2011 at 5:12 am
Not any more, 15,000 now 😀
To be very honest, I was thinking 1000 partitions are more than enough on a table and one might not need to cross this limit.
It...
October 10, 2011 at 8:47 am
give it some time maybe..
Yup… this is what I am going to do now… Leaving for the day 😀
October 10, 2011 at 8:39 am
Viewing 15 posts - 1,936 through 1,950 (of 2,007 total)