Welsh Corgi

Forum Replies Created

Viewing 15 posts - 1,816 through 1,830 (of 3,738 total)

RE: Error Restoring Differential after Restoring Full Backup WITH STANDBY error has not been restored to the correct earlier state.

GilaMonster (1/26/2012)
The error implies there were. Did you check MSDB backup tables? Did you check the LSNs in the full and diff backup headers?
I'm sure that is what happened but...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 26, 2012 at 7:41 am

#1438784
RE: Error Restoring Differential after Restoring Full Backup WITH STANDBY error has not been restored to the correct earlier state.

GilaMonster (1/26/2012)
Are you absolutely sure that the differential you have is based off the full backup that you restored? There were no other full backups taken between the time that...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 26, 2012 at 7:01 am

#1438752
RE: How to Ignore Report Parameter

wolfkillj (1/25/2012)
Welsh Corgi (1/25/2012)
The function is wrong.
Do you have a tested solution with that function?:w00t:
Oh, and by the way, I tested the function you posted earlier. It definitely works properly...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 25, 2012 at 4:26 pm

#1438493
RE: How to Ignore Report Parameter

ok, thanks but I get the same error.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 25, 2012 at 1:07 pm

#1438410
RE: How to Ignore Report Parameter

The function is wrong.
Do you have a tested solution with that function?:w00t:
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 25, 2012 at 12:50 pm

#1438395
RE: ODBC not showing SQL 2000 tables

gweiho4xd2 (1/25/2012)
Hi,
I don't have any client machines (all Win XP) which are able to see the list of tables/views on the SQL 2000 server over an ODBC connection.
I can see...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 25, 2012 at 12:14 pm

#1438366
RE: How to Ignore Report Parameter

wolfkillj (1/24/2012)
Your splitter function returns the expected results, but the code in the stored proc should select the column Item from the function in the subselect in the WHERE clause,...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 24, 2012 at 3:58 pm

#1438009
RE: How to Ignore Report Parameter

Not really..
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 24, 2012 at 3:11 pm

#1437996
RE: How to Ignore Report Parameter

This is the code for the function:
CREATE FUNCTION dbo.Split_Multi_Value_Parameters
/* This function is used to split up multi-value parameters */
(
@ItemList NVARCHAR(max),
@delimiter CHAR(1)
)
RETURNS @IDTable TABLE (Item NVARCHAR(100) collate database_default )
AS
BEGIN
DECLARE @tempItemList NVARCHAR(max)
SET...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 24, 2012 at 1:36 pm

#1437936
RE: How to Ignore Report Parameter

The delimiter is not working.:w00t:
I have the following in my Stored Procedure:
AND State IN (SELECT State FROM dbo.Split_Multi_Value_Parameters (@State, ','))
I perform a DBCC INPUTBUFFER (SPID) and it parses as follows....
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 24, 2012 at 12:00 pm

#1437880
RE: How to Ignore Report Parameter

wolfkillj (1/13/2012)
Welsh Corgi (1/11/2012)
After you have created the "splitter" function, your query syntax would look like this:
WHERE State in (select Item from dbo.DelimitedSplit8K(@State, ','))
I tried that but I still get...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 24, 2012 at 10:13 am

#1437801
RE: ODBC not showing SQL 2000 tables

You want to configure the DSN on the machine that you are having trouble with to use the same Login as the machine that is working.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 24, 2012 at 9:36 am

#1437770
RE: Setting up Database mail using gmail account

I tried this once with Yahoo and could not get it to work.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 23, 2012 at 12:25 pm

#1437313
RE: Restore from Differental Backup - Migrating to new Reporting Server

GilaMonster (1/23/2012)
You can restore the full backup WITH STANDBY, that makes the DB read only (as opposed to completely inaccessible as with WITH NORECOVERY), you can then query and investigate...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 23, 2012 at 10:53 am

#1437243
RE: ODBC not showing SQL 2000 tables

gweiho4xd2 (1/23/2012)
I've checked an old database which contains linked tables and can see the following in the MSysObjects table:
DSN=planning;APP=Microsoft Office XP;WSID=SYSTEM_ACCESS;DATABASE=planning
I appreciate your suggestions. Do you have any other ideas?
Simon
Simon,
ok,...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 23, 2012 at 10:30 am

#1437234

Viewing 15 posts - 1,816 through 1,830 (of 3,738 total)