Viewing 15 posts - 376 through 390 (of 812 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. ...
----------
Ashish
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.
----------
Ashish
February 2, 2011 at 6:00 pm
sorry for replying on your query.
----------
Ashish
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...
----------
Ashish
February 2, 2011 at 4:05 am
was the database dettached properly before its being attached?
----------
Ashish
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...
----------
Ashish
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...
----------
Ashish
February 1, 2011 at 4:08 am
need output like
id starttime ...
----------
Ashish
February 1, 2011 at 3:43 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...
----------
Ashish
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.
----------
Ashish
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
----------
Ashish
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.
----------
Ashish
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.
----------
Ashish
January 31, 2011 at 4:24 am
Viewing 15 posts - 376 through 390 (of 812 total)