Technical Article

If I restore a database without an ODBC datasource setup will it fail?

  • Topic

I have tried to restore a database using a different computer than usual, which did not have the ODBC datasource setup for the database concerned.  The database is basically stuffed - I got an error message stating "modify file encountered operating system error 112..."When I installed SQL Server on this computer I set it up […]


Technical Article

RE: Stored Proc and Master DB

  • Reply

I don't know how are you using the parameter but this sholud helpyou going Declare @str varchar(200) SET @str = DB_NAME()--Assuming is going to be runned from other databases only --otherwise use dbname as a parameter +'.dbo.sp_helprolemember ' + '''' + 'RoleName' + '''' --print @str exec (@str) I don't know why can't the "plus" […]


Technical Article

RE: datawarehouse with DTS + stored procs only ?

  • Reply

quote: Our warehouse is currently 26+ Gigs and we load it with delta's daily in under 2 hours (along with the recon reports for balancing). Our datawarehouse is currently only ODS (ADS to be started soon) and 160+Gigs. Our daily loads (including reindexing and reporting) must stay under 12 hours. Can you give an idea […]



Advent of Code 2022


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

Daily Coping 8 Dec 2022


Today’s coping tip is to be curious. Learn about a new topic or an...

#PowershellBasics: Warnings and how to hide them.


One of my favorite parts of having a new job is that I learn...

Read the latest Blogs


how to keep two databases with different collation on one instence

By rajemessage 14195

hi, i want to keep two databses with diffrent collation on one instence of...

The Enterprise Roadmap to Reducing Costs (While Increasing Value)

By Additional Articles

Comments posted to this topic are about the item The Enterprise Roadmap to Reducing...

The Temp Alias

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Temp Alias

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