Viewing 15 posts - 631 through 645 (of 1,409 total)
Why do you have the restriction of using the LIKE operator?
But you can accomplish this for example by using the LEFT or the SUBSTRING operator.
October 25, 2013 at 6:20 am
I'm not sure if this code is compatible with VBA, but I use this (modified for security reasons) code below in VB6:
Private Function GetConnectionstring(ByVal strDatabase As String) As String
Dim...
October 25, 2013 at 6:08 am
stefan_hufnagel (10/25/2013)
ADDITIONAL INFORMATION:An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
The database principal owns a schema in the database, and cannot be dropped. (Microsoft SQL Server, Error: 15138)
The...
October 25, 2013 at 5:32 am
Before opening the database with "app.OpenCurrentDatabase" you could first try to connect with an OLEDB connection. The OLEDB connection doesn't use a GUI so you can easily handle an error...
October 25, 2013 at 5:21 am
I guess the information on the URL is created before SP3 for SQL2005 was released.
Allthough I don't have much experience with an in-place upgrade from SQL2005 to SQL2008, I can't...
October 17, 2013 at 7:41 am
When running a database in FULL recovery mode it is required to take regular LOG backups. Without running LOG backups the space inside the LOG-file can not be re-used and...
October 17, 2013 at 5:26 am
It is not possible to attach a SQL2005 database on a SQL2000 instance. The only way to transfer your data-modifications from SQL2005 to SQL2000 is with export/import of data. You...
October 15, 2013 at 5:09 am
All actions that result in a "PRIMARY Filegroup FULL" error are being rolled back. These actions need to be executed again by the application/user. Some other actions (like simple SELECTs)...
October 15, 2013 at 4:25 am
Create a (temporary) table that hold all the month values. Outer-join this table with your table that holds the birthdays on the extracted month-value of that birthday. Group and total...
October 15, 2013 at 1:08 am
If I interpred your output correctly the value in column "original login" is xxxx\SAPServiceRED. This looks like a Windows account/AD-group to me. Can you check the value Red in column...
October 15, 2013 at 12:48 am
Just to verify your settings and active connections; can you post the results of the query below?
select
case when serverproperty('IsIntegratedSecurityOnly') = 0 then 'SQL' else 'Windows' end as security_setting
, sum(case when...
October 14, 2013 at 4:27 am
SELECT
convert(NVARCHAR(60), db_name(database_id)) AS [database]
,CASE command
WHEN 'BACKUP DATABASE'
THEN 'DB'
WHEN 'RESTORE DATABASE'
THEN 'RESTORE'
ELSE 'LOG BACKUP'
END AS [type]
,command
,start_time AS [started]
,dateadd(mi, estimated_completion_time / 60000, getdate()) AS [finishing]
,datediff(mi, start_time, (dateadd(mi, estimated_completion_time / 60000, getdate()))) -...
October 10, 2013 at 4:18 am
Take a look at this article (and included script): http://sqlmag.com/t-sql/plugging-gaps-sql-server-job-tracking.
Probably it will give you allready what you want. I only had to modify it slightly to fit my environment...
October 10, 2013 at 4:16 am
If you mean by "duplicate values" that the same value exists in multiple rows, you need to provide some sample data (CREATE TABLE and INSERT statements) so we can duplicate...
October 9, 2013 at 7:47 am
Most probably because the results without the CASE statement will also return duplicate records.
But for us to be able to help you, you should post your query and provide some...
October 9, 2013 at 4:59 am
Viewing 15 posts - 631 through 645 (of 1,409 total)