Viewing 15 posts - 2,191 through 2,205 (of 2,905 total)
I should add that there is a little bit of risk with SQL injection depending on what is in the code.
For example, the Query that is being executed is:
May 24, 2019 at 3:51 pm
This may not be the most elegant solution, but I believe it should work for you. Just need to un-comment the EXEC(@SQLCMD) line:
DECLARE @SQLCMD VARCHAR(MAX) = '';
DECLARE...
May 23, 2019 at 8:55 pm
Quick fix:
In the line "SET @SQLQuery", try casting your @intID to an NVARCHAR(255).
EDIT - re-read your post and I see you tried this already. Is it giving the same error...
May 23, 2019 at 3:20 pm
Can you post your query?
Looking at the screenshots the first result set shows row 91 and the second result set shows row 1. Since no row in data set 2...
May 22, 2019 at 9:18 pm
As a crazy thought, what happens if you try opening the error log file outside of SQL? With the new instance you can shut it down and have a look...
May 15, 2019 at 9:18 pm
Welcome to the forum and to SQL Server!
So looking at your queries, my understanding is the first one is adding columns to an already existing table. That one looks good...
May 14, 2019 at 9:58 pm
I have been working as a DBA for about 8 years (roughly) and I don't see the "light" at the end of the tunnel for becoming a Sr. DBA anywhere...
May 14, 2019 at 9:35 pm
I just realized I misread that configuration... it isn't 122 GB of memory, it is 12.2 GB of memory.
Depending on database size, that may be too small, but I'd still...
April 23, 2019 at 9:45 pm
When you say a "slow server", is it every query that is slow? Is it a specific stored procedure or view that is slow or everything you do on the...
April 23, 2019 at 9:00 pm
This may be an unpopular opinion, but I feel that this is more of a user training issue than a forum software issue.
If the end user uses the tool the...
April 22, 2019 at 9:30 pm
Looking at the query, your @Time1 and @Time2 variables are going to show the time difference between how long it takes to call GETDATE(). And that time is going to...
April 10, 2019 at 10:09 pm
I have a question about this:
When it gets suddenly slow, are you able to reproduce the slowness on your machine from SSMS?
What I am thinking is to...
February 12, 2019 at 9:31 am
Another way to get this inventory is through RedGate SQL Monitor.
Not sure where they scrape their data from, but in version 8 (possibly sooner) they have an Estate tab...
January 22, 2019 at 12:14 pm
As a thought, is your .NET up to date?
August 15, 2018 at 9:42 am
I quite enjoy being a DBA overall. Every now and then I get hit with odd problems that make me think and hopefully I have time to think and resolve...
August 10, 2018 at 8:42 am
Viewing 15 posts - 2,191 through 2,205 (of 2,905 total)