Viewing 15 posts - 91 through 105 (of 109 total)
Use the following script to know about the Windows Group in SQL Server
DECLARE @LoginName sysname
DECLARE @sql NVARCHAR (2000)
BEGIN
DECLARE cur_Loginfetch CURSOR FOR
...
July 21, 2009 at 6:42 am
The best place to learn about SQL Server 2005 is their official documentation. I would recommend you to download a copy of BOL.
You can download a copy of BOL from...
July 21, 2009 at 5:53 am
I'm talking about a general scenario... It can be any table...
The count(*) result gives results faster than the select * command... Although both these commands use a table scan(I'm...
July 21, 2009 at 4:04 am
Can I go ahead and limit the memory usage to say about 5Gb ?? Is there anything that will be affected due to this ??
And most importantly just to confirm...
July 10, 2009 at 9:38 am
The max server or min server memory limit had not been set.
The max memory limit is by default 2147483647 MB.
July 10, 2009 at 4:46 am
Yes. To shrink the log file use the DBCC Shrinkfile. In the DBCC command specify your log file name.
Shrinking the log file will not cause fragmentation of objects in the...
July 10, 2009 at 3:50 am
Is there any system table/tables that contain this information ??
April 16, 2009 at 7:36 am
Thanx for the quick response.
I was looking for a way to query if from Sql Server.
April 16, 2009 at 7:13 am
Most of the objects in this database are under the default schema (dbo).
So giving permissions on the schema won't work.
March 31, 2009 at 10:40 am
The user should have Create/Alter/Drop permissions for all the Sp's in the database but should not have Create/Alter/Drop Table permissions in the database.
March 31, 2009 at 7:45 am
If our database is in simple recovery mode. Is there any chance to overwrite the uncommitted data by any other user?
If this happened how to rollback the data from transaction...
February 3, 2009 at 10:36 am
Hi Jeff,
Done ?? Will converting text to varchar(max) allow me to view the complete data using a select statement in SSMS ??
Well I...
June 27, 2008 at 9:08 am
I'm retrieving the data through SSMS. The Result to Grid limits Non XML data to 65535. My text field has more data than this.
June 26, 2008 at 12:32 am
To change MSSQL table owner
sp_changeobjectowner '[DATABASE_NAME].[TABLE_NAME]' , 'NEW_OWNER_NAME'
😀
February 5, 2008 at 10:01 am
Issue solved !
I tried giving the sql server 2000 port number i.e,1433 nd it got connected.
The whole server name will look like this
[server name]\[Instance],1433
Was plannin for another installation actually. Hope this...
July 12, 2007 at 12:12 pm
Viewing 15 posts - 91 through 105 (of 109 total)