Viewing 15 posts - 556 through 570 (of 1,409 total)
First you need to clearly define the business rules to describe your update proces. (When do you update, what do you update, which new value do you use to update,...
January 15, 2014 at 11:27 am
Luis Cazares (1/15/2014)
You could use @@ROWCOUNT to validate resultset and GOTO or RAISEERROR to stop the procedure.
Keep in mind you need to read the @@Rowcount directly after the command you...
January 15, 2014 at 11:18 am
halifaxdal (1/15/2014)
...I do not have the password although I can use it to connect to the subject server/db...
Can you elaborate on how you currently use this ID (account) to connect...
January 15, 2014 at 11:13 am
SQLKnitter (1/14/2014)
To your first question, I do use exec msdb.dbo.sp_send_dbmail @profile_name = 'Send Mail'
a lot in SQL...
January 14, 2014 at 2:53 pm
Maybe as a more drastic solution:
- delete the USER from the database(s)
- delete the LOGIN from the instance
- create a new LOGIN and assign access rights to the database(s) (when...
January 14, 2014 at 2:35 pm
halifaxdal (1/14/2014)
I had a colleague with privilege and ran the sp_change_users_login, apparently some parameters must apply.
Sorry if I wasn't clear in my previous post. The full command is:
exec sp_change_users_login 'report'
Some...
January 14, 2014 at 2:28 pm
You need a login with enough permissions (for example the login you used when you created the new ID) to execute the "sp_change_users_login" command. This command will give information about...
January 14, 2014 at 12:15 pm
Check if the database user is connected to the login of the new login ID. Open a query windows in SSMS, set the focus to the desired database and execute...
January 14, 2014 at 11:47 am
Regarding the first error "unable to open step output file": Do you use the SP_SEND_DBMAIL stored procedure? Does it work if you execute it as an SQL Agent job on...
January 14, 2014 at 11:31 am
tonynlennard (1/14/2014)
AND P.txtSchoolID NOT IN (SELECT CONTACT.SERIALNUMBER FROM CONTACT)The problem is P.txtSchoolID is nvchar and contact.serialnumber is varchar so SQL generates a collation conflict error message.
You can add the desired...
January 14, 2014 at 11:18 am
David Burrows (1/14/2014)
You cannot cast 'EFT0000000220' to bigint.You can cast the numerical part, ie CAST(SUBSTRING('EFT0000000220',4,10) as bigint)
What David is saying: the text part "EFT" can not be converted to a...
January 14, 2014 at 8:00 am
I assume the error is genereated in the following line (can you confirm?)
sqlcmd = sqlcmd & _
" insert into #Eft_Transfer values ('" & strEftNo & "','" & strDate & "','"...
January 14, 2014 at 6:30 am
We can help you if you provide some table DDL (create table statements) and include sample data (insert statements). Give us also a sample of the output you wish, so...
January 14, 2014 at 6:24 am
Can you check if the mail is being sent (and failed) or the mail has not been sent at all?
You can execute the code below on the instance where you...
January 14, 2014 at 6:12 am
This error looks like the server is very busy and is under a lot of stress at that moment. Therefor it doesn't have the resources available to handle the login.
Setup...
January 9, 2014 at 10:54 am
Viewing 15 posts - 556 through 570 (of 1,409 total)