|
|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Adding Custom Error Messages | |
Who can add custom error messages to the sys.messages table? | |
Think you know the answer? Click here, and find out if you are right. |
Yesterday's Question of the Day (by Steve Jones - SSC Editor) |
Getting the columns I have a database and I call this procedure. EXEC sys.sp_columns @table_name = 'Articles' What is returned? Answer: A list of all the columns from the Articles table for my default schema Explanation: The sp_columns procedure returns a list of columns for the object(s) specificed in parameters. For just a table name, the table is determined by the default object rules for a user. If a different default schema is used, or the user owns an object by that name, then those columns are returned. Ref: sp_columns - https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-columns-transact-sql?view=sql-server-2017 |
Database Pros Who Need Your Help |
Here's a few of the new posts today on the forums. To see more, visit the forums. |
Missing stored procedure names from ReportServer.dbo.Catalog - I am trying to get a listing of all my SSRS reports along with the underlying stored procedure. I found some code, I appologize to the author for not remembering his name, that extracts the CommandType and CommandText to get “StoredProcedure” and the name of the stored procedure. The problem is…many of the report xml […] |
SSIS Question - We used to have all SSIS packages in files systems. As I’m upgrading them to the new server, I’d like to see your opinion where to store these packages, File System to MSDB? what’s the pos and neg ? |
Add to Briefcase doesn't work - Today I wanted to add one of the articles that came across in the SSC newsletter, to my Briefcase. I clicked on the Add to Briefcase link multiple times. It never seemed to work. At least it never indicated that I’d actually saved anything to my Briefcase. |
CREATE ANY LOGIN permission? - I am trying to allow a login to create other logins but not be able to alter or drop logins which already exist. The closest I seem to be able to get is the ALTER ANY LOGIN permission but this allows control of all logins. As there is no CREATE ANY LOGIN permission does anyone […] |
adding default column with type BIT and default value as Y - I want to add new column test to the table contact with type BIT with default value Y. PLease let me know how to do this |
adding default column with type BIT and default value as Y - i want to add new column test to the table contact with type of bit with default value Y please let me know |
Can't see number of reads for my posts - As a blogger whose posts are syndicated on SSC, one thing I liked was that I could go to my “author” page and see the number of reads for each post. That appears to be gone with the new design. Maybe there is another way I can check these numbers? If not it would be […] |
Broken Links in Google Searches - A lot of google search results that find SSC articles are coming up with a page not found error – rather than there being a re-direct to the new location. e.g. https://www.sqlservercentral.com/blogs/matthew-mcgiffen-dba/2017/12/05/overview-of-encryption-tools-in-sql-server/ |
NGrams8K Article Missing - https://www.sqlservercentral.com/articles/Tally+Table/142316/ – “Oops! That page can’t be found.”. It’s also, as a result, disappeared off Google: https://www.google.com/search?client=firefox-b-d&q=Ngrams8k DelimitedSplit8k and DelimitedSplit8K_lead are giving the same page errors. |
Images not displaying - In today’s issue of SQLServerCentral (4/4/2019), the topic is “Rebuilding SQLServerCentral”. At the bottom of the email, I saw a link for an article I clicked on: “From the SQL Server Central Blogs – Disk Space and SQL Server”: Disk Space and SQL Server The images display fine with Internet Explorer (Version 11.0.9600.19204). However, the […] |
Automatic Replication of DDL statements - This has been bugging me for sometime now. I’ve tried to read documentation from Microsoft and it confuses the crap out of me. What I’m trying to accomplish is when someone creates a new stored procedure, new table etc. I’m needing to have the new table, proc etc. added as an article and the subscription […] |
Option to use old forums? - I really don’t like the new forums. The layout makes it really hard to read posts containing a lot of technical information. Even on Mobile there is a ton of dead space https://pasteboard.co/I8DXvsL.jpg |
Mysterious permissions issue – SELECT denied on UPDATE - Hi, I have been working all day troubleshooting a SELECT permission denied error, and at first I thought I just did something really silly, but I’m becoming more and more convinced there may be some bug in SQL Server. 1. Executing the failed statement in SQL Server Management Studio using Run As Different User results […] |
Unable to get the results im expecting with a join or sub select - I have a query that pulls in from 7 tables.. One of those tables i just need 1 column returned for each record. The issue is that the table can have multiple records or no records.. and if there are multiple records, i just need to return 1 value, i dont need to have 3 […] |
SSIS Encryption - Has anyone else had a problem when they set an encryption password on their SSIS packages? I did all the steps to change security to EncryptSensitiveWithPassword while I was still in development mode. For a while it was working fine. Today I opened Visual Studio and loaded the project, it prompted me for a password […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |