Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
calisonic
Starting Member
32 Posts |
 Posted - 2015-03-06 : 20:17:55
|
| Can't even locate the Scripts folder. Doing a search for *.sql (with show hidden files enabled) returns no spconfig. I'm sure I'm doing something wrong. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-03-06 : 20:25:14
|
| What are you referring to? What is spconfig.sql? What scripts folder?Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
calisonic
Starting Member
32 Posts |
Posted - 2015-03-09 : 18:06:31
|
| Sorry, it's actually spconfigure.sql. I unfortunately don't know the folder. It's a file you open in SSMS and allows you to configure the server as far as backup compression default, remote login timeout, and server trigger recursion.I did a search on all of C: for *.sql and it didn't come up. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-03-09 : 18:38:44
|
| I think you are referring to sp_configure, but that's not a file, script or folder. It's a stored procedure. You execute it inside a query window in SSMS: EXEC sp_reconfigureTara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Next issue, cannot find spconfig.sql