trace flags

Technical Article

RE: Question of the Day for 05 Feb 2004

  • Reply

Erm, make that 10! PS, love those helpful messages that have just appeared on the left of the posting window - "Banner turned off on purpose" and "This banner not working right either!"Doesn't make me feel too bad about an intranet login page I forgot to change which happily informs the users "You are not […]


Technical Article

RE: need help

  • Reply

In that case try: Select Count(orderNo) as COrders, Month as theMonth into #TempCustOrders From Orders Where CustId = @CustId Group by Month Select t.COrders as CustOrders, Count(OrderNo) as TotalMonthOrders, Month From Orders inner Join #TempCustOrders t on t.theMonth = Month Group by t.COrders, Month Drop Table #TempCustOrders


Technical Article

RE: Pet Peeves

  • Reply

Yeah, he's a character alright! Seems like an incredibly inteligent guy, and he doesn't give a crap for what people think about him. Never realized until today quite how prolific he is...


Technical Article

RE: table

  • Reply

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Customers]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Customers] GO


Technical Article

RE: Saving Global Variables

  • Reply

Thanks a lot, using a little bit of your suggestion I have managed a workaround. This involves two activeX script tasks. The first loads the variables and is run before any other tasks. The second saves them and is run after every other task. It seems to work very well. This is the code in […]


Technical Article

RE: Task Pad view in Enterprise Manager

  • Reply

I wish. I have asked this question before and have gotten no good leads. I have heard though, that once you select it to be the view EM will remember it. I have mixed results with this method, but sometimes it does remember the view. Chris Doesn't know nuthin about nuthin, but don't tell nobody. […]


1 reads


Flyway Desktop Projects for My PoC


In a previous post, I set up the basic databases for the PoC project...

Daily Coping 30 Jan 2023


Today’s coping tip is to plan something fun and invite others to join you....

Migrating or Recovering a TDE Protected Database 


When encrypting a database with Transparent Data Encryption (TDE), a vital consideration is to...

Read the latest Blogs


Database copies (cross environment) and sizing strategies for 2019

By MyDoggieJessie

I'm sure this has been asked many, many, many times and hoping several optimal...

TSQL to determine status of subscription reinitialization

By ratbak

How do I determine the initialization status of a subscription with T-SQL -- i.e,...


By sqlguru

Has anyone migrated databases from on premise SQL Server to Azure Managed instance? If...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers