I have transactional replication configured in production. I am wondering if we could rename the publication database in transactional replication without having to drop and recreate the replication set up. Also, is it possible to rename the database files of the publication database without affecting the replication configuration.
2012-04-10
2,618 reads
SQL Saturday comes to Wisconsin and Madison on Apr 21, 2012 with world famous brats for lunch. Sign up for a free day of SQL Server training.
2012-04-10
1,811 reads
Are multiple binary switches becoming hard to manage? The TestBits function can help with that.
2012-04-09
4,230 reads
Come to a free day of SQL Server training in Houston, TX on Apr 21, 2012.
2012-04-09
1,737 reads
I have a stored procedure I push down to all of my servers that does a custom backup job and I want to make sure all servers have the same stored procedure. Is there some way to check without going to each server and reviewing the stored procedure? Check out this to find out.
2012-04-09
4,522 reads
The 'bin packing' problem isn't just a fascination for computer scientists, but comes up in a whole range of real-world applications. It isn't that easy to come up with a practical, set oriented solution in SQL that gives a near-optimal result.
2012-04-06
2,537 reads
Learn how to build a CLR function that can be used to perform string manipulations that might be rather complex in T-SQL.
2012-04-05
8,169 reads
If you are running an instance of SQL Server 2005 and above then most likely that instance is running the default trace. This default trace is a canned Profiler server side trace that automatically starts up when SQL Server starts. In this article Greg Larsen explains more about the default trace and shows you how to glean some event information from the trace files created by this background trace process.
2012-04-05
3,916 reads
This SSIS package generates XML invoice documents from data stored in SQL Server, then FTPs and/or Emails them to clients.
2012-04-04
6,844 reads
Red Gate Software has released Version 3.0 of SQL Monitor, a performance monitoring and alerting tool.
2012-04-04
1,009 reads
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
While doing some housekeeping I came across a folder containing some scripts that appear...
Comments posted to this topic are about the item Why SQL Server Database Attach...
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers