Viewing 15 posts - 316 through 330 (of 13,460 total)
SearchAllTables from stack overflow explicitly ignores date/datetime datatypes.
peek at the code:
AND DATA_TYPE IN ('char', 'varchar', 'nchar', 'nvarchar', 'int', 'decimal')
modify your version to use datetime data...
Lowell
July 15, 2018 at 6:26 pm
in SSMS, if you drag the columns folder from the SQL object explorer to an ssms window, all columns will appear as a comma delimited list.
it's easier then to...
Lowell
June 11, 2018 at 6:30 am
SQL doesn't have a rowtype equivalent.
ROWTYPE , in sql terms for me, is used in a cursor as a collection of all the @parameters that would correspond to each...
Lowell
June 11, 2018 at 6:20 am
We have an Audit in place that captures Login created or Login Changed.
I have seen on patch nights, those same logins get dropped and recreated as part of the patches;
i...
Lowell
May 3, 2018 at 3:20 pm
it's gotta be permissions. Lowell
here's my suggestion:
On the SQL Server, Create a credential that has your actual username and password, because we know it works when you execute it.
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
May 3, 2018 at 3:03 pm
can you create some Aliases in SQL configuration manager, so, for example servers named [ProdCluster01] and [ProdETSource] etc etc are all aliased to point to your local machine? or to...
Lowell
May 1, 2018 at 3:12 pm
the verb was just so it mirrored the filename and process; it just seemed right;
This was republished today , as it had some relevancy for new folks.
Lowell
April 27, 2018 at 12:48 pm
use a script task instead of a file system task;
the code would look something like this:
Lowell
string WorkingDirectory = (string)Dts.Variables["WorkingDirectory"].Value;
string ArchiveDirectory = (string)Dts.Variables["ArchiveDirectory"].Value;
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
April 13, 2018 at 2:40 pm
how are you sending the data to CSV in your job step? sqlcmd? bcp? powershell? SSIS? both sqlcmd and bcp can add those delimiters , and force column widths . Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
March 19, 2018 at 9:52 am
ok i was able to duplicate the error and a resolution. here's the tiny differences.
I created am XLSX document , with a default sheet name of Sheet1.
i used...
Lowell
March 19, 2018 at 7:50 am
Lowell
March 18, 2018 at 8:19 am
yes, with a calculated, persisted column, that uses the real identity column.
Note this is just creating a formatted version of your identity, so it's a little repetitive.
You might...
Lowell
March 18, 2018 at 8:14 am
the error is most likely inside your function.
DBO.get_account_id_by_invoice_date( i.invoice_id )
just based on the name, it's probably trying to find the "latest" invoice, but what if...
Lowell
March 14, 2018 at 8:14 pm
my comments got lost somehow.
the issue the OP is encountering is the Service Account that the SQL Agent runs under does not have access to "C:\Users\myName\Desktop\WUpdates\"
that path is a private...
Lowell
January 31, 2018 at 5:22 pm
Lowell
January 29, 2018 at 8:16 am
Viewing 15 posts - 316 through 330 (of 13,460 total)