Viewing 15 posts - 2,296 through 2,310 (of 6,676 total)
Thom - these issues are related to datetime/smalldatetime data types. The format YYYY-MM-DD is a valid ISO date format but is not handled correctly in SQL Server when using either...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 30, 2019 at 6:01 pm
I don't use it a lot - but I do have several scripts where it is very useful. For example - creating logins/users in an AOAG environment. The script creates...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 28, 2019 at 3:12 pm
You want the text qualifier to be set to double quotes. That is set in the connection manager for the file.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 11, 2019 at 10:48 pm
Thanks. I might be missing something here but we seem to be creating a table and populating it – I don’t see how we end up with a physical file....
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 11, 2019 at 9:43 pm
I created and saved an SSIS package. On the “Control Flow” screen, I would expect to see a “Run” or “Execute” button, so I can manually run the package &...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 11, 2019 at 5:18 pm
The ideal solution would be to publish the report to SSRS - and schedule it to export to an Excel or PDF file as needed.
Since you do not want to...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 6, 2019 at 3:59 pm
You stated you had previously granted update access to the user - once granted it will remain until explicitly revoked. So now this user has db_datareader role AND explicit...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
March 31, 2019 at 4:37 pm
The agent service actually runs under a special service SID account (NT SERVICE\SQLSERVERAGENT). That account has sysadmin rights to SQL Server and allows the agent jobs to run with...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
March 31, 2019 at 4:32 pm
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
March 27, 2019 at 11:53 am
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
March 26, 2019 at 12:24 pm
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
March 26, 2019 at 11:54 am
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
March 26, 2019 at 11:39 am
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
March 25, 2019 at 12:42 pm
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
March 25, 2019 at 12:29 pm
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
March 20, 2019 at 2:42 pm
Viewing 15 posts - 2,296 through 2,310 (of 6,676 total)