Viewing 15 posts - 226 through 240 (of 13,457 total)
if you are using SQL Database mail, you can query the msdb database:
if the smtp server returns an error, like no such mailbox, you can see it in there.
February 21, 2019 at 6:22 pm
are you using fully qualified names for the DNS? like myServer.AlphaTangoWhiskey.com, or just the name that has to be resolved, like myServer?
can you test and see if it makes...
February 21, 2019 at 6:13 pm
for your BCP, can you explicitly convert to varchar, so it's not a custom type on exoprt?
February 21, 2019 at 6:12 pm
here's a complete example like Sue_H is referencing:sqlcmd -S stormserver\SQL2016 -Q "SET NOCOUNT ON;select TOP 10 * from DBA.dbo.Algorithm" -o c:\data\myfile.csv -h-1 -s","
The parameter flags...
February 21, 2019 at 6:10 pm
is this a pure bulk insert or a merge component or something?
give is a bit more info onthe package design please.
also , are you using lookups to join...
February 21, 2019 at 1:55 pm
all those interim versions from 5+ years ago are gone,and only the latest are maintained.
these are the links, which is @ version 3.18, i need to post my latest...
February 21, 2019 at 9:41 am
you are trying to access a file in your private protected space
C:\Users\mp88_\OneDrive\Desktop\samplefile.txt
if you ran bcp from the command line itself. YOU have access to that file.
but...
February 19, 2019 at 2:24 pm
this might be a case of you being familiar with using the Excel automation hammer, and everything looks like a nail....
a lot of what you pointed out can...
February 19, 2019 at 8:42 am
I am in the same situation, I have reviewed the answers that you have received but I have only managed to get the procedure executed but no emails come...
February 18, 2019 at 3:18 pm
there is no need to install office on a server.
SSIS will use the ACE drivers to create excel documents, so there is no need to install Office , and...
February 18, 2019 at 6:52 am
something like this should work:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
GO
IF OBJECT_ID('tempdb.[dbo].[#Results]') IS NOT NULL
DROP TABLE [dbo].[#Results]
GO
CREATE TABLE [dbo].[#Results]...
February 12, 2019 at 8:38 am
restore the table from a backup. you have permanently converted the previous data to bad data/question marks instead of retaining the original values. February 12, 2019 at 7:04 am
Turkish characters sets use
it changes, base don the version of SQL you connect to.
a connection to SQL2008R2, for example, does not have the columns [NetAddress],[ExecutionCount],RequestID], but a connection to SQL 2016 does...
February 12, 2019 at 6:29 am
parameter sniffing gone wrong can often(almost always?) be related to statistics being out of date.
look at the tables being used in the procedure; it only takes a small percentage...
February 11, 2019 at 1:46 pm
from inside the procedure, the commands run in the order you created them in, and there is no way for the third to execute before the previous commands complete.
February 10, 2019 at 6:39 am
Viewing 15 posts - 226 through 240 (of 13,457 total)