Viewing 15 posts - 31 through 45 (of 60 total)
Chris its not required sp_MS_marksystemobject will do the magic without running allow updates, believe me i have tested it. 🙂
April 3, 2009 at 12:07 pm
There are certain loopholes in your requirement - There is no direct way to deny login for pure sql logins, yes its ok for windows login.
Anyways, I have some...
April 3, 2009 at 11:58 am
it will copy all objects (including constraints, PS, function etc, whatever valid for SQL server), at least its true for SQL server to SQL server. I dont know how it...
April 3, 2009 at 9:14 am
1. Create a new database (as schema in oracle is like database in sql, database in oracle is like server instance in sql )
2. You can use DTS Import...
April 3, 2009 at 2:59 am
It depends, for my enterprise, we can connect to any sql server from our central monitoring server.
April 3, 2009 at 2:45 am
matija (4/3/2009)
Is there any why to pass variable to command:alter table add id identity(@xy,1)?
Tnx
Try this
create table new_one(name varchar(30), city varchar(20))
declare @xy int
set @xy = 100
exec('alter table new_one add...
April 3, 2009 at 1:20 am
If you cant connect to servers, nothing much can be done
Try to run this on such a server, where you have access to maximum servers
I have update the...
April 3, 2009 at 1:10 am
Carefully read all updates in service packs and try to figure out, what is clashing with your code.
April 2, 2009 at 11:52 pm
Jerry Hung (4/2/2009)
gregIf you are on SQL 2005, look into PowerShell as well, it is great for this purpose. Google for some examples to grab server versions
I think, Powershell is...
April 2, 2009 at 6:58 pm
Going back to more than one log files issue .. its true this will not improve performance , but real life is tougher than our recommendations .. yes, in enterprises...
April 2, 2009 at 9:40 am
Thats great.. I was thinking the same for 2k5 and as i have installed several instances, i never thought of it... it seems easy for me to install sql (and...
April 2, 2009 at 9:21 am
Ok. Use this
EXEC sys.sp_MS_marksystemobject your_stored_proc_name
and you are done. This SP is now a system SP. Same is true for any object (table, function ...)
April 2, 2009 at 9:06 am
Yes.
http://msdn.microsoft.com/en-us/library/ms165724(SQL.90).aspx
Read full -
"
If the SQL Server Browser service is not running, you can still connect to SQL Server if you provide the correct port number or named...
April 2, 2009 at 8:41 am
what is this dts admin role?
I think your permissions are overkill ... u require less than what u have ...
ask some admin to check any denied permissions. ...
April 2, 2009 at 7:31 am
GUI showing percent free in minus is common for large tempdb's, I dont know exactly why is this, but I have seem in several servers.
April 2, 2009 at 4:24 am
Viewing 15 posts - 31 through 45 (of 60 total)