Arsh

Forum Replies Created

Viewing 15 posts - 61 through 75 (of 335 total)

RE: Indexing a character column

Hi Grant,
Thanks for pointing out my typo. Yes, I meant the data type of those columns in question being Non-Numeric. Was a bit concerned about the search mechanism...

September 4, 2018 at 6:40 am

#2004337
RE: Cursor object running when @@FETCHSTATUS 0

Dear All,
I've simplified the code for the test case , and now it looks like below . Though there are no records , the control goes in While...

August 5, 2018 at 3:40 am

#2000299
RE: Cursor object running when @@FETCHSTATUS 0

Dear All,
I've attached the SP in this file for reference in case the code is not readable in the 'Post' window here. Quick advise / input on...

August 5, 2018 at 3:16 am

#2000297
RE: Left padding a FLOAT type with zeroes

andycadley - Sunday, July 29, 2018 4:26 AM
If you know the values will always be whole numbers, you could cast it to...

July 29, 2018 at 7:45 am

#1999388
RE: SA user unable to access a database

Jeffrey Williams 3188 - Thursday, July 26, 2018 11:58 AM
EXECUTE AS login = 'user login';
GO
EXECUTE {database}.{schema}.procedure
GO
REVERT;
GO
Hi Jeffrey,
Got it working by removing...

July 29, 2018 at 1:35 am

#1999383
RE: SA user unable to access a database

Jeffrey Williams 3188 - Wednesday, July 25, 2018 12:44 PM
You don't need to deny privileges to the user in D2 - which...

July 25, 2018 at 11:25 pm

#1999033
RE: Fetching cols from multiple tables in a cursor query

alastair.beveridge - Monday, July 23, 2018 4:18 AM
why would you want to do this in a cursor?
but if you really do, you...

July 23, 2018 at 7:04 am

#1998582
RE: Comparing E mail address through SP

Hi Thom A and Thom R,
The objects provided you works well. I simulated this in our scenario of invoking the SP from another DB after grant execute and...

July 3, 2018 at 4:38 am

#1996110
RE: After Insert trigger

Arsh - Sunday, July 1, 2018 12:01 AM
Jeff Moden - Monday, June 25, 2018 6:24 AM

July 3, 2018 at 2:19 am

#1996097
RE: Grant Execute on an SP

Arsh - Sunday, July 1, 2018 12:43 AM
Erland Sommarskog - Thursday, June 28, 2018 5:40 AM

July 1, 2018 at 1:51 am

#1995936
RE: Grant Execute on an SP

Erland Sommarskog - Thursday, June 28, 2018 5:40 AM
Yet a caveat with cross-DB chaining is that persons who have permissions to create...

July 1, 2018 at 12:43 am

#1995932
RE: After Insert trigger

Jeff Moden - Monday, June 25, 2018 6:24 AM
Arsh - Monday, June 25, 2018 1:27 AM

July 1, 2018 at 12:01 am

#1995931
RE: Grant Execute on an SP

Erland Sommarskog - Thursday, June 28, 2018 2:31 AM
Only granting access will not work, as User1 does not have access to DB2.
Certificate...

June 28, 2018 at 3:55 am

#1995581
RE: After Insert trigger

John Mitchell-245523 - Monday, June 25, 2018 2:07 AM
What do you get if you run this?
SELECT
entity_name
, subentity_name
, permission_name
FROM fn_my_permissions...

June 25, 2018 at 2:36 am

#1995099
RE: Calculating memory for SQL Server on a VM machine

While there's no specific algorithm to get a magic number, what one has to do is to first get an ideal about much memory the applications need . To...

April 7, 2018 at 1:47 am

#1985876

Viewing 15 posts - 61 through 75 (of 335 total)