Viewing 15 posts - 301 through 315 (of 373 total)
henrik staun poulsen (10/27/2010)
It that the correct (international) way to hard-code dates?
I think I would have used '2010-01-31' or is it '20100131' to ensure that it will work around the...
October 27, 2010 at 12:29 am
You are referring SQL 2005, so
please refer: http://msdn.microsoft.com/en-us/library/cc917715.aspx
October 26, 2010 at 10:50 pm
You can create Indexed view - add Index on the view.
As per BOL:
"An indexed view is a view that has been materialized. This means it has been computed and stored....
October 26, 2010 at 10:48 pm
MonsterRocks (10/26/2010)
DECLARE @PVC_LOGIN_USERVARCHAR(40),@PVC_APPLICATION_IDVARCHAR(40),--yet to finish
@PVC_PROGRAM_NAMEVARCHAR(40),
@PI_RET_STATUSINT,
@PVC_RET_MSGVARCHAR(500),
@PI_RET_ERRORNUMINT,
@PVC_APPLICATION_NAMEVARCHAR(50), @pvc_dest int;
my declaration is mentioned above
As per the declaration above, I dont see any errors while executing...
October 26, 2010 at 2:36 am
Good question with nice/tricky options.
I was thinking for following options are the candidates:
ALTER DATABASE db2 SET DISABLE_BROKER ; ALTER DATABASE db2 SET ENABLE_BROKER;
ALTER DATABASE db2 SET NEW_BROKER
But after reading...
October 26, 2010 at 12:45 am
ruchir 71291 (10/25/2010)
Thanks for providing good solution.Before I change datatype from ntext to nvarchar(max), I would like to know the difference between ntext and vvarchar(max).
Thanks,
Ruchir
ntext datatypes will be deprecated in...
October 25, 2010 at 12:17 am
You can also use "xp_logevent"
like: EXEC xp_logevent 60000, <<your message>>, informational
It Logs a user-defined message in the SQL Server log file and in the Windows Event Viewer. xp_logevent can be...
October 22, 2010 at 12:33 am
WayneS (10/21/2010)
Simon-413722 (10/21/2010)
Hi,I'm just wondering if you could register and take MCITP exam and skip MCTS?
I want to clear 70-431 - Microsoft.SQL.Server.2005.Implementation.and.Maintenance in next month but...
October 21, 2010 at 10:00 pm
I was thinking that due to multiple user is entering the data at same time, it may generate primary key violation.
October 21, 2010 at 4:16 am
w.rooks (10/21/2010)
The error you will get is: CostomerMast does not Exist!!!The table is called CostomerMastER
This was typo mistake.
If you change it to CustomerMaster still SQL throws an error:
Cannot truncate table...
October 21, 2010 at 12:40 am
Nice question.
Delete is working for CustomerMaster table but truncate throws an error. I would like to know why it is not working? Any specific reason?
October 20, 2010 at 11:51 pm
As per the BOL:
To view the Activity Monitor in SQL Server 2005 and SQL Server 2008, a user must have VIEW SERVER STATE permission.
To view the Activity Monitor on...
October 19, 2010 at 11:56 pm
Really nice question & good knowledge sharing conversation.
October 19, 2010 at 9:05 am
Viewing 15 posts - 301 through 315 (of 373 total)