Viewing 15 posts - 1,531 through 1,545 (of 2,462 total)
Sa is administrator, is has rights of everything. Some companies disable the "sa" account and let users handles everything with windows auth. So windows auth can be restricted to...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 23, 2010 at 12:20 am
Thanks to all 🙂
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 22, 2010 at 4:31 am
can you update the SP ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 22, 2010 at 4:09 am
IF we think aboout security and unauthrized restriction then "windows authentication" would be better.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 21, 2010 at 3:53 am
sam_mastermind (7/12/2010)
But truly I want to know it............... and i think that is the most important thing.
If this is the case then 🙂
http://msdn.microsoft.com/en-us/library/ms179478.aspx
http://msdn.microsoft.com/en-us/library/ms190440.aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 20, 2010 at 7:03 am
joshanil (7/19/2010)
my db is full recovery mode
recently i take a full backup but don't have any log backup
after half...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 20, 2010 at 6:57 am
jprabha.d (7/16/2010)
Please Let me know how can i write the sql query to get this result
Post some sample data along with your query.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 20, 2010 at 4:57 am
sushantkumar1984 (7/19/2010)[hr2) started the sql server browser (sql server configuration manager--> services)(it was off earlier)
Have you stopped it earlier intentionally or is it a newliy built server.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 19, 2010 at 9:49 pm
sqlbuddy123 (7/15/2010)
If a clusterd index already exists, you can specify NON CLUSTERED clause to create a noon...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 19, 2010 at 2:10 am
What actually do you want to retrieve as information ?
may be this link can help you http://support.microsoft.com/kb/907877
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 15, 2010 at 1:54 am
Yes you can create
ALTER TABLE dbo.RFP_NSO_SEND_QUEUE ADD CONSTRAINT
PK_RFP_NSO_SEND_QUEUE_rfp_nso_send_queue_stub PRIMARY KEY NONCLUSTERED
(
rfp_nso_send_queue_stub
) WITH( FILLFACTOR = 75, PAD_INDEX = ON, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,
ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 15, 2010 at 1:51 am
google it as i did
http://sqlblogcasts.com/blogs/madhivanan/archive/2008/08/27/dynamic-pivot-in-sql-server-2005.aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 14, 2010 at 1:47 am
shahbaz_awan (7/14/2010)
is it possible to write dynamic query for it ?
yes it is possible
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 14, 2010 at 1:05 am
USe pivot table approach
USE DOMAIN_DBA
GO
DECLARE @t TABLE (EMP_ID int , Contact_type nvarchar(50), Contact_Number nvarchar(300))
INSERT INTO @t
SELECT 1 ,'Home' ,'92 - 51 - 225478'
UNION SELECT 1, 'Cell', '92 -...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 14, 2010 at 12:04 am
Viewing 15 posts - 1,531 through 1,545 (of 2,462 total)