| Here's a few of the new posts today on the forums. To see more, visit the forums. |
| SQL Server 2017 - Development |
| Can't find my option to run my package in my toolbar - I need help running this package of my but my run button is no where to be found. |
| SQL Server 2016 - Administration |
| SQL Agent Jobs - I have a developer who want's to run sql agent jobs as temporarily. Like create the sql agent job dynamically, run (job is very simple) and when the job completes then delete it on fly. Would you see any problems doing this way? Otherwise do you recommend any other options? Please advise? |
| AlwaysOn Failover Execution Cache - Hello I would like to know on the event of a SQL Server AlwaysOn failover, what is the effect of the query performance? How long it takes to generate the execution cache as the existing queries running in the primary node will not go to Stand by node. |
| Upgrading to SQL 2016 - Hi All I am upgrading from SQL 2012 Std to SQL 2016 Std. A quick question I wanted to run past you guys..... Can I take the Master & MSDB mdf's and ldf's from the new 2016 instance and replace it with the mdf's and ldf's from the 2012 instance in attempt to bring across […] |
| Sudden growth in mdf file - Please assist I have faced a sharp growth in the size of my primary data file on SQL Server 2016.How can I identify the cause of the issue. |
| Development - SQL Server 2014 |
| Question about Default Database For a SQL Login - SQL Server 2014 (13.0.5598) PROBLEM; 5 days ago when connecting to the SQL Server that hosts (in the cloud) our database I discovered that the ALTER VIEW STATE permission had been removed and I was now being connected to a different database by default then the one I had been for the last 9 months […] |
| SQL 2012 - General |
| How to do the following trace one a database server and on a table? - I have some troubles in doing following trace, thanks for kind help! 1. aside from opening SQL profile or extended event, How to monitor or trace who and when logining SQL server ? 2. How to know/trace who and when excecuting insert?update or delete or select statement on one table? |
| SQL Server 2012 - T-SQL |
| input character string does not follow style 112, either change the input ch - Hi, I'm getting an obscure issue when when I run this SQL statement SELECT TOP 1 S_Date from tbl_name order by RowID I get this error message : Msg 9807, Level 16, State 0, Line 1 The input character string does not follow style 112, either change the input character string or use a different […] |
| View Dependencies - I have SQL Server 2012 and running the following query. THe results do not include all dependencies. I have a stored proc that calls a view, but that does notshwo up. How do I get full dependency list? SELECT ReferencingObjectType = o1.type, ReferencingObjectName = o1.type_desc, ReferencingObject = SCHEMA_NAME(o1.schema_id)+'.'+o1.name, ReferencedObject = SCHEMA_NAME(o2.schema_id)+'.'+ed.referenced_entity_name, ReferencedObjectType = o2.type, ReferencedObjectName […] |
| SQL Server 2008 Performance Tuning |
| Insert statement hung but select works normally - I have a question thrown to me by my developers, according to them, they notice that on a high load SQL server, their insert jobs is taking a long time to complete however all their select statement doesn't have any impact at all as the select completed very quickly. I told them, most select statement […] |
| Reporting Services |
| SSRS 2012 Folder Settings not showing - Hello experts, We have an SSRS 2012 instance. Due to organization policy, I need to connect to the Report Manager using RDS / Work Resources. When I connect using the Work Resources Internet Explorer, I try to click 'Folder Settings' from the Home folder to add an AD account to the permissions. However, when I […] |
| SSRS 2019 DB account issues - Hi, I've been having some issues trying to get a brand new SSRS install deployed. I have setup a brand new Windows 2019 server install along with SSRS 2019. I have the SSRS DB hosted a a separate Windows 2016/SQL2017 server. I have configured SSRS to use the Virtual Network service account and am […] |
| Powershell |
| Finding specific file with dynamic date - I need to find a file with a specific date in it. The problem is I never know what the date will be except "today". The date is formatted as yyyyMMddhhmm. Since it was created earlier in the day by an automated process, I need to be able to find it by ignoring the hhmm […] |
| Integration Services |
| SSIS Catalog and Github - Hello, the new environment I am working at now wants to use GitHub for version control, and SSIS for ETL, and wondering if SSIS integration catalog will work well with GitHub? or is it only going to work with SSIS by file? thanks in advance |
| SQL Server 2005 General Discussion |
| Attachments EMail - I'm having trouble trying to get my query results loaded into my excel attachment can anyone help. DECLARE @sub VARCHAR(100) DECLARE @qry VARCHAR(1000) DECLARE @msg VARCHAR(250) DECLARE @query NVARCHAR(1000) DECLARE @query_attachment_filename NVARCHAR(520) SELECT @sub = 'DC Weekly Transfer' SELECT @msg = 'This is Just a test.' SELECT @query_attachment_filename = 'dcweekly.csv' Declare @nOrgID int = […] |
