Search
-
Re: Log Shipping as a reporting database.
You can use this script to kill all the users in a given database prior to executing a log restore. CREATE PROCEDURE sp_Kill_All_Processes @pDbName varchar (100)=NULL, /*database where we will kill processes. If NULL-we will attempt to kill processes in all DBs*/ @pUserName varchar (100)=NULL /*user in a GIVEN database or… -
Re: Error Migrating SmartAssembly Database to SQL
Hello I have a similar problem after updating from version 6.9.0.114 to version 6.11.1.363 gets the error: i call MigrateDataFromMDB.exe: C:\Program Files\Red Gate\SmartAssembly 6\MigrateFromMDB>MigrateDataFromMDB.exe "C:\ProgramData\Red Gate\SmartAssembly\database.mdb" ".\SQLEXPRESS" Log and exception: 97300 rows copied… -
Re: Help with evaluation
Hi Erik, Firstly may I apologize for the delay in responding (there seems to have been an issue with forum notifications at our end). Unfortunately there isn't currently a way to have Windows users scripted as "without login". I'm not exactly sure why the behavior differs between SQL Auth and Windows users. This is… -
How is remote debugging allowed on Microsoft SQL Management studio?
This is working with Sql Server version 2008 R2. This is not a production server. And I am running SQL Server Management Studio to debug a stored procedure. Here are the other versions of software that might be helpful: How is remote debugging allowed on Microsoft SQL Management studio? This question might be… -
SQL Monitor GUI Error How to increase Pool Size and timeout?
Discussion by DonFerguson · · Home› Discontinued and Previous Versions› SQL Monitor Previous VersionsI was having performance issues with the SQL Monitor Base monitor, so I had the resources on the base monitor server increased. Now the base monitor is frequently timing out. The significant part of the error message I am receiving is: "The timeout period elapsed prior to obtaining a connection from the pool. This may have… -
SQL Monitor 5.0.11 released
We've released SQL Monitor 5.0.11, which you can download here. Features • SRP-10220: Improved messaging on the Add SQL Server screen to clarify what syntax is required • SRP-10289: The Edit and Remove options for maintenance windows are now accessible directly from the maintenance window column • SRP-10393: The… -
*** SQL Refactor 1.3 Released ***
Discussion by [Deleted User] · · Home› Discontinued and Previous Versions› SQL Refactor Previous VersionsWe are very pleased to announce the release of SQL Refactor v1.3. You can get it from http://www.red-gate.com/products/SQL_Refactor/index.htm This is a recommended upgrade for all current SQL Refactor users who would like to use SQL Refactor on SQL Server 2008 client. Bug Fixes: • Fixed the disappearing dialog issue… -
Unable to complete running sql package due to function error
I created a package and when I ran it it gave me the following error:- An insufficient number of arguments were supplied for the procedure or function. When I ran the function in the database, it ran fine. Any idea what is wrong. Here is the function: /* This is used on the PM Schedules Look Ahead Report in the PM Section… -
Failure during validating db state, ignoring filter file
Hello, I have TeamCity configured to run a SQL CI build of a database using a filter file. We'd previously done an evaluation of all these products on a different server - everything was working fine and the filter file I'd configured was being used. The main purpose of the filter file is to ignore a series of views that… -
Re: SQL Backup Pro 7 - SQBCoreservice.exe - Running at 97% CPU
Hi, thank you for your forum post. The SQBCoreService.exe or the SQL Backup Agent service, controls all functionality of SQL Backup. It communicates with the SQL Backup GUI when the server is registered in the SQL server pane. The SQBCoreService.exe will continue if there are backup and restore tasks in progress. The SQL…
>1649 results