Here's a few of the new posts today on the forums. To see more, visit the forums.
|
| SQL Server 2017 - Administration |
| backup issues - Cannot open backup device. Operating System error 5. SQL Backup failing to network share. SQLServer service runs under NT Service\MSSQLSERVER. Is changing to a network service or domain account the only option ? NT Service\MSSQLSERVER is Not searcheable in the network share folder. Any interim solutions. Thanks |
| database auditing specification - Hi. In database audit specification mentioned principal name - SQL user which all DML transactions captured by that particular user. I want capture all users like widows authentication and SQL authentication both. what principal name need to be mention? Thanks |
| recovery model for model database - Hi All, Is it good to leave "model" database recovery model as "FULL:" or change it to simple? is it just to ensure the newly created user databases to have FULL recovery model or is there any other good reason ? I see log backup pending for model database that's why asking this question. […] |
| SQL Server 2016 - Administration |
| List Procedure That Creates A Table - I've been trying to develop a process that will take the input of a table name and trace that back to a stored procedure that creates, updates, or inserts into it. I've been piecing together queries using the sys.sql_dependencies, sys.sql_expression_dependencies, dbo.sysobjects, and dbo.syscomments tables but I'm not able to get the results that I'm looking […] |
| SQL 2012 - General |
| Add file to Primary FileGroup - I had a drive running low on disk space where the mdf resides, so I created a new ndf file on the Primary filegroup on a different drive. How do you know when it's being written too? Are there any queries that can tell you that? How does it distribute(balance) so original drive doesn't completely […] |
| SQL Server 2012 - not accepting new connections on occasion ... - SQL Server 2012 running on Windows Server 2012 R2. Microsoft SQL Server 2012 (SP4-GDR) (KB4583465) - 11.0.7507.2 (Intel X86) This occurs occasionally, maybe once every 2 weeks or so, the DB server does not accept new connections. Existing connections are OK, but it will not accept new ones. It requires a restart of the SQL […] |
| SQL Server 2019 - Administration |
| Size of DB Log File - hi I was looking at the size of my db. The log looks really big. It is supposed to be that big? here is the query i used to get this information: SELECT mdf.database_id, mdf.name, mdf.physical_name as data_file, ldf.physical_name as log_file, db_size_MB = CAST((mdf.size * 8.0)/1024 AS DECIMAL(8,2)), log_size_MB = CAST((ldf.size * 8.0 / 1024) […] |
| SQL Server 2019 - Development |
| Combine rows into pivoted output - Hello and thanks if you can help, I am trying to combine 2 rows into pivoted out. One of the pivoted column needs to come form one row and the second pivoted column needs to come form the other row. I am working in a view and this is a much highly simplified example so […] |
| Job Activity Monitor Error - I am new here and I hope this is the place to place this question. When I schedule an Agent Job Activity it fails with the error: Login failed for user 'LCDOM100\LCISQL##'. [SQLSTATE 28000] (Error 18456) Cannot open database "LCDW" requested by the login. The login failed. [SQLSTATE 42000] (Error 4060). The step failed. This […] |
| Reporting Services for Linux - Hello! I'm using SQL Server Express 2019 on Linux. I would like to use Reporting Services for this server, and I know that this is not possible with linux. Somebody knows a good alternative of a reports server for linux? Thank you. |
| Integration Services |
| Could not find file - Please assist. I don't know if the actual file does not exist( it does not exist in mentioned folder) or if the file path in the variables are the problem. Am i jumping the gun here? [Excel Source - Master Data Reference [14]] Error: System.IO.FileNotFoundException: Could not find file '\\ZADURFS01\Departments\Finance\Business Intelligence, Reporting and Analytics (BIRA)\Source […] |
| Suggestions |
| What is Data Cleansing and what is the importance of Data cleansing for B2B - Hello Recently when I was talking to my friends I came to know about data cleansing, they told me that data cleansing will be helpful for B2B database, but I did not know about data cleansing and it is not useful for B2B business. How important it is for you. Please guide me regarding data […] |
| SQL Server 2022 - Administration |
| Need list of all TBLs and VWs in PUB (exclude Procs and UDFs) - This SQL renders all articles in a PUB including TBLs, VWs, Procs and UDF's: SELECT * FROM distribution.dbo.msarticles WHERE publication_id = 6 order by article Is there a way to EXCLUDE the Procs and UDF names from this result? thx in advance. |
| SQL Server 2022 - Development |
| Data modeling tooling - Just wondering what people might be using as a data modeling tool these days? Looking for a tool that might help generate documentation as well. Thanks! |
| How To Extract specific key Value from the string that has key value pairs - How To Extract Values from the string that is key value pairs with different formats I have a table called DataForce. with column DataVal (Nvarchar 2000). it has below 3 records How to get CID Value, ID Value, Email Value, Zip from below strings please advise? {'ani':'80052242','dnis':'90425935','cid':'4601923812','Id':'046067ce-7fec-4af7-bb51-e4d31b4720','No':'3048','FN':'Bod Conner','Ent':'2012-08-27','Email':'sounage@nefcom.net','Add':'P.o. Box 146','Zip':'31040','Not':'English','Off':'FL','ACode':'','OffId':'0002 Home Office FL','Except':''}, {"ani":"30926539","dnis":"33300180","cid":"4594296356","Id":"a2a5bac2-b6ad-4239-95b2-2da730c2b6","No":"93872","FN":"Martinael […] |
