Forum Replies Created
Viewing 15 posts - 2,071 through 2,085 (of 6,679 total)
-
Reply To: is there any better way to export SQL server data into csv file?
WILLIAM MITCHELL wrote:The OP stated "I want to make a report to let user export data from SQL Server database" so why not consider SSRS?
This also has the benefit of allowing...
-
Reply To: [SOLVED]Migrating databases - error on login 4064 (cannot open default database)
The users in the database were originally created on the source system - and were created with a specific SID. When you restore that database to a new system -...
-
Reply To: Prevent Record Deletion
Is this a direct DELETE statement - or are they calling a stored procedure to perform the delete? If calling a procedure - and they have execute permissions on the...
-
Reply To: query a new vendor database
The best way is to contact the vendor and request that information - hopefully they are able to provide it for you, even if it is just a subset for...
-
Reply To: Any redundancy on SSIS Worker Server
Based on my quick review - HA is available through windows clustering for the Scale-Out Master service and AlwaysOn for the SSISDB catalog.
The service will be installed on each node...
-
Reply To: SQL Server Agent replacement
So - you have a bunch of SSIS packages stored in the file system and SQL Server Agent jobs are setup to execute those SSIS packages?
If that is the case,...
-
Reply To: weird sql problem.
Also - be careful with referencing columns without using the table alias.
Select po_num
From poitem_all
Where poitem_all.po_num Not In (Select po_num From preqitem)In...
-
Reply To: SQL Server Agent replacement
It sounds like you have an integration services server - which would have SQL Server Integration Services installed. For the ETL processes - review how they are configured...are they referencing...
-
Reply To: Database file size question
I would recommend reviewing this article: https://www.sqlskills.com/blogs/paul/important-change-vlf-creation-algorithm-sql-server-2014/
I don't think it will apply - as long as you are not using an very small fixed size for growth of the log.
-
Reply To: Drillthrough Reports
How are you getting to the parent report? If you are linking to that report from another source - then that link can be configured to disable the navigation buttons. ...
-
Reply To: Drillthrough Reports
The last button is the back button - which will return you to the parent report without refreshing the data.
-
Reply To: Flat File connection configuration
Brad Allison wrote:I believe the stored procedure implicitly returns the double quotes to capture the field as there are some addresses with commas. What is the best practice in SSIS to...
-
Reply To: Identity column as Primary Key - good or bad?
roger.plowman wrote:That's actually a plus. 🙂 True names, and all that. Is the lack of resets also true for the TRUNCATE verb?
No - truncate will reset the identity value to...
-
Reply To: Issues using sys.dm_io_virtual_file_stats dmv to check CheckDB Reads
rvsc48 wrote:CheckDB when running primarily effects IO for the TempDB database and not so much on the database you are running it on. Try running your query against TempDB while...
-
Reply To: User accounts
Admingod wrote:Would that transfer the passwords for sql account?
Yes - it creates the new login with the same password and the same SID. Because the SID is the same -...
Viewing 15 posts - 2,071 through 2,085 (of 6,679 total)