===EDIT===  Sorry, I missed the part about "other than set up a job". As far as I know, there is no other way.

Setup a job specifically to cleanup...

For SQL Server 2012, I mitigate these STIG findings with an extended event. I scripted the xevent and have included it below. Please change the folder used for the xevent files...

Just to clarify, the CNO needs the "Create computer objects" permission on the AD container in which the CNO resides.

The AG Listener has its own name and IP addresses. If you have a multi-site cluster, you need one IP for each subnet. Once the listener is added from SQL...

Thanks for the reply. Yes, the data file can grow without limit. It's just under 100 GB.

Congratulations, Jeff.

You have been deserving of an award like this for years. As a long-time SSC member and regular tally table user (and calendar table!), I thank you for...

If you get a "Login failed for user 'ead'. Reason: Not associated with a trusted SQL Server connection." error whle trying to login in with a standard SQL login, than...

Did you modify the correct noise word file? I can't tell what country your from, but in the USA the noise word file is noise.enu. I think the .eng is...

Lowell is right about the double quotes - they should be single quotes. Otherwise SQL Server thinks your are referring to a column name ( unless someone ran the statement SET...

Another way:

1. Run DBCC CHECKIDENT('DAWNTEST', RESEED, 499999)

2. Insert a second copy of the data into the table

3. Delete the old data from the table.

I ran your query (without the UDF, since you didn't provide any code for that), and it returned one row (which is probably the expected result) with all of your...

Do you run the SQL Server Agent using a domain account? If so, have the network people give that account read access to the .csv folder (they may have to...

I work for a government agency that uses Lotus Notes / Domino.

I actually got email working just now in about 15 minutes using the extended stored procedure XPSMTP mentioned above.

The...

I'm not sure I understand the exact problem you are having.

Are you trying to pass unicode strings that contain characters with Unicode value such as 3523, 3538, 3458, 3524 and...

Assuming you want to accomplish the task from T-SQL, you could use Sugesh's idea of using FIND, but without using a batch file. You may have to adjust the code...