Viewing 15 posts - 2,326 through 2,340 (of 49,571 total)
I strongly recommend you move the login auditing to SQLAudit or Extended Events rather.
They're far more suitable for this kind of audit, and doing so means that your error...
September 28, 2016 at 7:04 am
mcfarlandparkway (9/26/2016)
Now i want to use this function in my stored procedure to get code and lcode values?
With the really vague question and lack of details, hard to say anything...
September 27, 2016 at 1:31 am
Err, what do you mean by 'select statement of the stored procedure'?
I assume this is a table-valued UDF. If so, then it's used in the FROM clause of a select
SELECT...
September 26, 2016 at 2:03 pm
With login success being logged to the error log, you don't, not without a nasty amount of text processing. It's one of the more useless settings I've seen, makes the...
September 26, 2016 at 1:58 pm
Create a job that runs at the start of a year or database trigger on create table that regenerates the view with the tables that do exist. Dynamic SQL to...
September 26, 2016 at 1:48 pm
call.copse (9/26/2016)
"If you really can't fix the problem then,"Can't fix the problem? Does this situation really occur? Everything is fixable one way or another...
Yes, it happens. I've had a couple...
September 26, 2016 at 11:08 am
Yanum_Vlad (9/25/2016)
I still do not catch, how Full (!) log backup works when Bulk Minimal logging is in place.
BOL states:
Under the bulk-logged recovery model, if a log backup covers...
September 25, 2016 at 12:58 pm
Good, now maybe ask your boss about sending you on a basic T-SQL course, if you're going to be working with database code a lot.
September 24, 2016 at 5:31 am
If everything's going to the same SAN array, then you only separate for easier space management, so that a runaway TempDB won't also make the user DBs run out of...
September 23, 2016 at 9:49 am
No, you can't change the definition of the system views.
September 23, 2016 at 9:13 am
Mike Scalise (9/23/2016)
September 23, 2016 at 9:05 am
Eirikur Eiriksson (9/23/2016)
the @with additional parameters should be all in one line, something along this line:
@with = 'replace ,move "Logicalfilename" to "F:\Data\TestDB.mdf" ,move LogicalFilenameofLog" to "F:\Logs\TestDB.ldf"'
Restore is whitespace agnostic, the...
September 23, 2016 at 8:25 am
I strongly recommend you remove that file, as you are very likely in violation of the UK data privacy laws by posting personally identifying data in public.
Post made up data...
September 23, 2016 at 6:38 am
ScottPletcher (9/22/2016)
Also, be aware that some plans are never cached at all, for example, a trivial plan to satisfy "select * from table_name".
Trivial plans have been cached since SQL 2005....
September 22, 2016 at 12:51 pm
lmk1 (9/22/2016)
I have it set to PRINT in the example code for testing purposes, but eventually I don't want to print, I want to drop.
The PRINT is just so you...
September 22, 2016 at 12:50 pm
Viewing 15 posts - 2,326 through 2,340 (of 49,571 total)