Viewing 15 posts - 2,026 through 2,040 (of 5,109 total)
Due to GDPR coming in, I've been told I need to send encrypted PDF's...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 21, 2018 at 7:56 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 21, 2018 at 7:46 am
Thanks for the reply. I still have all my documenation from when I installed it...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 21, 2018 at 7:05 am
A database, in SQL Server, doesn't have a password; each login has a password. I'm not familiar with Control M, but it sounds like you're provided the wrong credentials. I'd...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 21, 2018 at 6:57 am
Ideally, don't do this in SQL Server but in your presentation layer. Things like SSRS (using a Matrix) or Microsoft Excel (using a Pivot Table) is far easily. Is this...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 21, 2018 at 3:05 am
Found it! https://www.sqlservercentral.com/Forums/1935691/Corruption-of-the-file-format-mdf#bm1955086
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 19, 2018 at 4:05 am
I'm 99% positive that this has been posted before (I recall finding the idea of an MDF getting well again (it had a cold? 🙂 ) quite amusing).
The...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 19, 2018 at 4:02 am
Ire
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 18, 2018 at 6:02 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 17, 2018 at 11:24 am
PRINT @SQL;
Your best friend when debugging dynamic SQL. Debug the SQL output from the PRINT, and then propagate any fixes the the SQL that generated your dynamic SQL.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 17, 2018 at 10:55 am
I very much doubt you need all of those columns in your Clustered Index. Have a look at this article from Redgate: https://www.red-gate.com/simple-talk/sql/learn-sql-server/effective-clustered-indexes/.
Notice, the description says...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 17, 2018 at 5:45 am
You could, with a trigger, however, I don't recommend it. Sounds like you need to create a role or set the permissions of the users/roles at a schema level.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 17, 2018 at 5:22 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 16, 2018 at 5:51 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 16, 2018 at 5:48 am
What do you mean "mapped"? Do you mean the service account that the SQL Server Agent runs under doesn't have a user on that database? If not, then no the...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 16, 2018 at 3:37 am
Viewing 15 posts - 2,026 through 2,040 (of 5,109 total)