Viewing 15 posts - 376 through 390 (of 2,356 total)
suggestion pls
How about showing us what you have actually tried? Have you even attempted to write this query yourself???
April 19, 2022 at 9:32 pm
I think I would start here:
There is no need to concatenate the variables into your code. That is SQL Injection at it's finest. Use the variables as...
April 19, 2022 at 8:51 pm
I think I would start here:
There is no need to concatenate the variables into your code. That is SQL Injection at it's finest. Use the variables as parameters.
Also, it...
April 19, 2022 at 6:05 pm
Have you looked at the SQL job that is created when you schedule a report?
You should be able to leverage that code to generate your set of 18 reports.
April 19, 2022 at 5:28 pm
FROM [' + @Server_id + ']. [' + @Name + '].[sys].[database_files]
That's your issue. You are declaring it in the dynamic SQL , yet you are referring to it outside of...
April 19, 2022 at 4:54 pm
The DMVs I've looked into have the CPU usage with only millisecond accuracy, which is fine for a large enough time window, but not at a batch level. It...
April 19, 2022 at 1:34 pm
Thanks Michael, I will take a look at that.
Thank you homebrew01, I didn't know I could do that but will when I revise the backup plan.
Hence my previous statement:
Do...
April 18, 2022 at 6:59 pm
Now, I am not trying to be a wise-guy, but with levels of "un-cooperation" that exist at your workplace, I would be leaving. Fast.
Is xp_cmdshell enabled? Re-start the SQL service...
April 18, 2022 at 6:35 pm
I don't think SSMS is even available in Mac OS.
Whoops. Missed that part. Sorry!
April 18, 2022 at 6:08 pm
Are you authenticated with a domain? If so, you do not specify a user and password. SSMS know your login and password, and passes it through to SQL.
If...
April 18, 2022 at 6:03 pm
Since you have that layer protected (MFA for VPN and logging into the physical machines), do you need MFA for the database layer?
I don't have MfA for...
April 18, 2022 at 5:55 pm
Use Windows Authentication. Universal with MFA won't work on an on-prem database.
That might very well be the issue. Okay, so how do I switch user to use "Windows...
April 18, 2022 at 5:53 pm
We have something like that running that captures all queries being executed on the server.
What did that fail to show you? I'm making a large assumption, but if this...
April 18, 2022 at 5:00 pm
Use Windows Authentication. Universal with MFA won't work on an on-prem database.
April 18, 2022 at 4:58 pm
Run this when the file is large. It will list the number of backups in the file.
RESTORE HEADERONLY FROM DISK = 'YourDatabaseBackupFile';
GO
Do yourself a favor. Make your backup strategy more...
April 18, 2022 at 4:52 pm
Viewing 15 posts - 376 through 390 (of 2,356 total)