Viewing 15 posts - 1,381 through 1,395 (of 2,462 total)
Lowell (8/26/2010)
SELECT
SCH.schema_id, SCH.[name] AS schema_name, ...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 26, 2010 at 5:44 am
GilaMonster (8/26/2010)
It does work, I've done it more than once.
not working for me declare @t table ( id int )
declare @i int ,@top int
set @i =...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 26, 2010 at 5:07 am
i am not able to see the required "include column" . i can only see the system related info.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 26, 2010 at 4:52 am
@gail
i tried but couldnt
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 26, 2010 at 4:36 am
can u brief about your requirement ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 26, 2010 at 1:53 am
You can also go for C2 Auditing but be careful, as it increase the overhead on resources.
C2 auditing records information goes beyond server-level events, such as shutdown or restart,...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 26, 2010 at 12:34 am
whenevr we restore any DB ,basically we lose the mapping between login and users which is done by column "sid" , So this columns values should be matched.
select *...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 26, 2010 at 12:23 am
Check this link
http://www.sqlservercentral.com/Forums/Topic570042-5-1.aspx#bm571110
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 26, 2010 at 12:11 am
State=16 means that the incoming user does not have permissions to log into the target database. So for example say you create a user FOO and set FOO's default...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 26, 2010 at 12:09 am
I would say, remove the transaction's logic from Sql (database side). because acc to your logic doesnt care about transaction as it is trying to insert data before the Database...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 25, 2010 at 11:32 pm
Warren Peace (8/25/2010)
Select * From OPENQUERY([HOUSEOFPAIN], 'EXEC HOUSEOFPAIN.BRUISE..sp_SmackDaFoo '''coworker''', '''7/4/2010''', '''cried'''')
i guess you have added extra quotes. play with single quotes
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 25, 2010 at 10:44 pm
Thanks to all
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 25, 2010 at 6:07 am
DBCC shrinkfile also require space to do the shrinkage
take log backup ( if it is in FULL recovery) then try to do shrinking
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 25, 2010 at 4:03 am
if possible , post your query which is being used for migration
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 25, 2010 at 4:01 am
DECLARE @T TABLE ( NAME VARCHAR(20), PWD VARCHAR(20))
INSERT INTO @T
SELECT 'Mary' ,'At connect'
select CAST(datalength(name) AS VARCHAR) + left (pwd,4) from @T
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 25, 2010 at 12:34 am
Viewing 15 posts - 1,381 through 1,395 (of 2,462 total)