Viewing 15 posts - 1,366 through 1,380 (of 6,676 total)
Did you restart the reporting service after granting the elevated rights? Verify permissions on the accounts NT SERVICE\SQLSERVERAGENT and NT SERVICE\MSSQLSERVER.
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
January 25, 2021 at 9:00 pm
You are welcome - thank you for the feedback.
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
January 25, 2021 at 8:52 pm
--==== Sample data
Declare @testTable Table (Category char(1), [Month] int, Amount int);
Insert Into @testTable (Category, [Month], Amount)
Values ('A', 1, 5)
...
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
January 25, 2021 at 6:28 pm
You can get around that issue by creating a new database at 130 compatibility - and place your code in that database. You will need to use 3-part naming or...
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
January 25, 2021 at 6:06 pm
To be able to view the definitions of objects - and therefore see them in Object Explorer - you need to GRANT VIEW DEFINITION to the user in the database.
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
January 25, 2021 at 5:58 pm
For the date column comparison - you should use the following:
AND FSS.SNAPSHOT_DT >= DATEADD(dd, -1, CONVERT(DATE, SYSDATETIME())
AND FSS.SNAPSHOT_DT < CONVERT(DATE, SYSDATETIME())
Assuming FSS.SNAPSHOT_DT has the data type...
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
January 24, 2021 at 5:38 pm
This is actually quite simple - the problem is in your where clause. When you outer join a table - you get all results from the preserved table (the left...
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
January 24, 2021 at 5:27 pm
Okay, I don't have control over the DNS process. I filled out a form and sent it along. I'm told it's set up the same as working instances. Also,...
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
January 22, 2021 at 5:57 pm
I think part of the problem is that a CNAME only defines the IP address - and not a port. Using just 'MickeyTest2' gets you to the IP address -...
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
January 22, 2021 at 5:27 pm
You might be able to setup a Powershell script to do this - and setup the agent job to execute that script. A simple driver table to identify the parameters...
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
January 22, 2021 at 5:20 pm
Is the SQL Browser service running?
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
January 22, 2021 at 4:23 pm
Answered on SQL Team: https://forums.sqlteam.com/t/summary-query-for-number-of-attendees-out-of-all/18890/6
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
January 21, 2021 at 10:50 pm
For a bunch of string fields, numbers you're absolutely right.
I use the last excel file, which I just go into and change the query save it and send it....
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
January 20, 2021 at 7:25 pm
I know I'm not answering your question here.
I'd be mindfull about copying and pasting data from SQL to Excel because of locales; how does Excel know what format your...
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
January 20, 2021 at 3:54 pm
The question is about knowing datetime2 doesn't contain the time zone, not how to convert to a different datatype.
The question is misleading:
I need to assign this value from a...
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
January 19, 2021 at 8:12 pm
Viewing 15 posts - 1,366 through 1,380 (of 6,676 total)