Viewing 15 posts - 76 through 90 (of 476 total)
In your specific version of SQL, there may be different columns returned by the FILELISTONLY command
In case helpful I've dug this out of my restore code. Hopefully the version-specific...
February 16, 2021 at 4:01 pm
You can write code to search stored procedures ...
I had a bit of a rethink on this. My dynamic SQL issue needs solving, but no harm in sorting out...
February 16, 2021 at 2:40 pm
Kristen, you might try this: http://blogs.lobsterpot.com.au/2021/02/09/adapting-the-tools-of-my-trade/
That looks spot on, thanks.
Our execs are not the Rock Star type ... but, that apart, I like Brent Ozar's setup. He has...
February 13, 2021 at 8:02 am
Such a list exists in SQL Server in the sys.syslanguages system compatibility view
Much better idea 🙂 That will also bring to light, and allow checking for, any month names,...
February 13, 2021 at 7:11 am
Unless I am misunderstanding something here
ADD a record with a PKey value "X"
Delete that record with PKey "X"
Add a new record with PKey "X" is absolutely fine, as at that...
February 12, 2021 at 8:32 pm
You can write code to search stored procedures, views and functions for specific strings
Thanks. However enough of the SQL within our Sprocs is mechanically generated, bolting together various...
February 12, 2021 at 5:48 pm
I see more people that have desks using their couches for meetings.
🙂
I've read about people analysing backgrounds in video conferences ... And apparently people are buying bulk-lots of "suitable...
February 12, 2021 at 5:23 pm
This perhaps?
DECLARE @MyString varchar(255)='E:\Backup\Server1\Database1\Database1_131983519013.bak'
SELECT RIGHT(@MyString, CHARINDEX('\', REVERSE(@MyString)) - 1)
February 12, 2021 at 4:52 pm
I'm in the UK too ... I expect my IT challenges over the last 12 months are much the same as everyone else.
We have always had "capability" to work from...
February 12, 2021 at 4:23 pm
If each individual file is not language specific (i.e. dates within the file are mixture of languages) my inclination would be to extract all the DISTINCT month names, ideally in...
February 12, 2021 at 1:20 pm
Certificates are more secure as only objects with the certificate (eg SPs) can access the permissions on the user with the certificate in the other database. They would mean...
February 12, 2021 at 10:09 am
But is it even possible to get the first 25 and last 25 pages of data from the data pages since Data pages constantly keeps moving during Index Reorg...
February 11, 2021 at 4:48 pm
Sorry, was only intending to clarify that I am not using cross DB chaining.
I had considered using different logon for QA database, which would have permission for QA_OTHER_DATABASE and no...
February 11, 2021 at 4:42 pm
I'm curious how they are planning to "copyright" it ... and what the front-and-back portions actually achieves in practice.
How about: take a backup, post it to yourself, make sure the...
February 11, 2021 at 2:49 pm
Expecting an in-situ upgrade on a 21 year old server is asking a bit much too!
February 11, 2021 at 2:45 pm
Viewing 15 posts - 76 through 90 (of 476 total)