Technical Article

RE: How to shrink logfiles

  • Reply

I have tried regular transaction log backups (daily), but the .trn files just keep piling up in the backup directory and and are not being removed even though i specified to have them removed (files older than a day) in the maintenance plan.  Any suggestions?


Technical Article

RE: Linked server security

  • Reply

Sorry about that.  Here is what the error message says:The server detected the following syntax errors in the command:  Error 7314:  OLE DB provider 'server2' does not contain table 'Rbc_datawarehouse.dbo.cmsbatch'.  The table either does not exist or the current user does not have permissions on the table.  OLE DB error trace [Non-interface error:  OLE DB […]


Technical Article

Dynamically Build Table Data Type

  • Topic

I am attempting to write a UDF that reads from INFORMATION_SCHEMA.COLUMNS and then based on a given TABLE_NAME, creates a new table datatype that mimics the structure of the aforementioned table.  my first guess was to implement a scalar UDF and return a single value of type table.I declared my UDF as:CREATE FUNCTION udf_clone_table  (@TableName […]


1 reads

Technical Article

RE: Question of the Day for 27 Jul 2004

  • Reply

I created the two tables and entered data in them exactly as stated in the question and ran statements A and B. Both returned the exact same result as below. The only difference was the heading for the third column, one said UniqueID, the other Unique_ID. FRED 1 3 FRED 2 3 FRED 3 3 […]



What Do I Do to Relax?


I’ve republished an editorial today from another author, called What do you do to...

Daily Coping 9 Dec 2022


Today’s coping tip is to find out something new about someone you care about....

Advent of Code 2022


Foreword Advent of Code is an annual event in which participants solve a series of...

Read the latest Blogs


SSRS - Add end date for all SSRS subscriptions

By pwalter83

Hi, Could you please advice if it is possible to add an end date...


By saintor1

I have been using this for a long time.   It was done initially in...

blank page

By carjara

Hi guys! The topic "Connect to SQL Server with Python to Create Tables, Insert...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The Temp Alias

See possible answers