Viewing 15 posts - 376 through 390 (of 816 total)
Michael L John (2/2/2011)
crazy4sql (1/31/2011)
its as simple as this.....as you cant rename the system database, similarly you cant rename the servername
This is what you said in a previous post. ...
February 2, 2011 at 6:22 pm
1) sp_dropserver 'OldServerName'
2) sp_addserver 'NewServerName', local
3) then Retstart mssql
this is useful for linked server.
February 2, 2011 at 6:00 pm
sorry for replying on your query.
February 2, 2011 at 4:29 am
how I can know the version of a SSRS 2005 already running.
I might not be getting your question clearly, but so far I understand, SSRS 2005 is version only.
The...
February 2, 2011 at 4:05 am
was the database dettached properly before its being attached?
February 2, 2011 at 4:00 am
Can anyone give me an easier approach to analyze (or) how to do an estimate of the Database ?? And how do we calculate the index size ??
by default if...
February 1, 2011 at 4:12 am
Owner of the DB
select suser_sname(owner_sid) from sys.databases
AutoIncrementof DB
what do you mean by this
Recovery MOdel of aDB
select recovery_model_desc from sys.databases
No.of Maintaince plan
select * from sysmaintplan_plans
No.of SP'S,No.of UDF'S,No.OF Triggers...
February 1, 2011 at 4:08 am
Isn't it possible to use more than one condition inside if exists() ?
There are not two condition, there are totally 2 different select statement which are no where related to...
February 1, 2011 at 2:43 am
the error you getting after running the query, clearify the reason itself.
See the error in your query result window.
January 31, 2011 at 11:33 pm
its as simple as this.....as you cant rename the system database, similarly you cant rename the servername
January 31, 2011 at 10:48 pm
The only option I can see here is reinstall sql server with new/correct instance name and attach the database from old instance.
January 31, 2011 at 10:27 pm
reader and wirter can be given to a user from database role.
To give permission of execute on all/specific SP, you can give 'grant exec' permission on all/specific SP.
January 31, 2011 at 4:24 am
Viewing 15 posts - 376 through 390 (of 816 total)