Red Gate forums

More about IBM 000-283 certification exam

janson — Sat, 25 May 2013 08:39:13 GMT

I can read more IBM 000-283 certification exam objectives and topics from the official site. However, I want to get more study materials or practice exam for it. Please recommend it.

Request for XpsPrint.dll

mgaffigan — Sat, 25 May 2013 00:06:15 GMT

I have a signature for XpsPrint.dll - StartXpsPrintJob, but nowhere to put it. I was hoping someone could create the new module. Thank you again for the great service provided to the .Net community.

I will post the signature below until the topic is created.

Code:

#region P/Invokes

public static void StartXpsPrintJobSafe(
string printerName, string jobName, string outputFileName,
SafeWaitHandle progressEvent, SafeWaitHandle completeEvent,
bool[] pagesToPrint,
bool getPrintJob, out IXpsPrintJob printJob,
out IXpsPrintJobStream documentStream,
bool getTicketStream, out IXpsPrintJobStream ticketStream)
{
if (string.IsNullOrWhiteSpace(printerName))
throw new ArgumentNullException("printerName");

byte[] pagesToPrintB = null;
UInt32 cpagesToPrintB = 0;
if (pagesToPrint != null && pagesToPrint.Length > 0)
{
pagesToPrintB = pagesToPrint
.Select(b => b ? (byte)1 : (byte)0)
.ToArray();
cpagesToPrintB = (UInt32)pagesToPrintB.Length;
}

IntPtr ppPrintJob = IntPtr.Zero;
IntPtr ppTicketStream = IntPtr.Zero;
// memory is allocated by StartXpsPrintJob, we just specify we want something
if (getPrintJob)
{
ppPrintJob = Marshal.AllocCoTaskMem(Marshal.SizeOf(typeof(IntPtr)));
Marshal.StructureToPtr(IntPtr.Zero, ppPrintJob, false);
}
if (getTicketStream)
{
ppTicketStream = Marshal.AllocCoTaskMem(Marshal.SizeOf(typeof(IntPtr)));
Marshal.StructureToPtr(IntPtr.Zero, ppTicketStream, false);
}

// take references on safehandles
IntPtr pProgressEvent = IntPtr.Zero;
IntPtr pCompleteEvent = IntPtr.Zero;

if (progressEvent != null)
{
bool success = false;
progressEvent.DangerousAddRef(ref success);
if (!success)
throw new ObjectDisposedException("progressEvent");
pProgressEvent = progressEvent.DangerousGetHandle();
}
if (completeEvent != null)
{
bool success = false;
completeEvent.DangerousAddRef(ref success);
if (!success)
throw new ObjectDisposedException("completeEvent");
pCompleteEvent = completeEvent.DangerousGetHandle();
}

RuntimeHelpers.PrepareConstrainedRegions();
try
{
// Preservesig is set, so this will throw on failure
StartXpsPrintJob(printerName, jobName, outputFileName,
pProgressEvent, pCompleteEvent,
pagesToPrintB, cpagesToPrintB,
ppPrintJob, out documentStream, ppTicketStream);
}
finally
{
if (pProgressEvent != IntPtr.Zero)
progressEvent.DangerousRelease();
if (pCompleteEvent != IntPtr.Zero)
completeEvent.DangerousRelease();
}

if (getPrintJob)
{
IntPtr pPrintJob = (IntPtr)Marshal.PtrToStructure(ppPrintJob, typeof(IntPtr));
printJob = (IXpsPrintJob)Marshal.GetTypedObjectForIUnknown(pPrintJob, typeof(IXpsPrintJob));
Marshal.FreeCoTaskMem(ppPrintJob);
}
else
{
printJob = null;
}

if (getTicketStream)
{
IntPtr pTicketStream = (IntPtr)Marshal.PtrToStructure(ppTicketStream, typeof(IntPtr));
ticketStream = (IXpsPrintJobStream)Marshal.GetTypedObjectForIUnknown(pTicketStream, typeof(IXpsPrintJobStream));
Marshal.FreeCoTaskMem(ppTicketStream);
}
else
{
ticketStream = null;
}
}

[DllImport("XpsPrint.dll", EntryPoint = "StartXpsPrintJob", PreserveSig = false)]
private static extern void StartXpsPrintJob(
// 0
[MarshalAs(UnmanagedType.LPWStr)] String printerName,
[MarshalAs(UnmanagedType.LPWStr)] String jobName,
// 2
[MarshalAs(UnmanagedType.LPWStr)] String outputFileName,
IntPtr progressEvent, // HANDLE
// 4
IntPtr completionEvent, // HANDLE
[MarshalAs(UnmanagedType.LPArray, SizeParamIndex = 6)] byte[] printablePagesOn,
// 6
UInt32 printablePagesOnCount,
IntPtr xpsPrintJob,
// 8
out IXpsPrintJobStream documentStream,
IntPtr printTicketStream);

#endregion

#region Structures

[Guid("7a77dc5f-45d6-4dff-9307-d8cb846347ca")]
[InterfaceType(ComInterfaceType.InterfaceIsIUnknown)]
internal interface IXpsPrintJobStream
{
void Read([MarshalAs(UnmanagedType.LPArray)] byte[] pv, uint cb, out uint pcbRead);
void Write([MarshalAs(UnmanagedType.LPArray)] byte[] pv, uint cb, out uint pcbWritten);
void Close();
}

[Guid("5ab89b06-8194-425f-ab3b-d7a96e350161")]
[InterfaceType(ComInterfaceType.InterfaceIsIUnknown)]
internal interface IXpsPrintJob
{
void Cancel();
void GetJobStatus(out XPS_JOB_STATUS jobStatus);
}

[StructLayout(LayoutKind.Sequential)]
internal struct XPS_JOB_STATUS
{
public UInt32 jobId;
public Int32 currentDocument;
public Int32 currentPage;
public Int32 currentPageTotal;
public XPS_JOB_COMPLETION completion;
public Int32 jobStatus;
};

internal enum XPS_JOB_COMPLETION
{
XPS_JOB_IN_PROGRESS = 0,
XPS_JOB_COMPLETED = 1,
XPS_JOB_CANCELLED = 2,
XPS_JOB_FAILED = 3
}

internal enum WAIT_RESULT
{
WAIT_OBJECT_0 = 0,
WAIT_ABANDONED = 0x80,
WAIT_TIMEOUT = 0x102,
WAIT_FAILED = -1
}

#endregion

Run out of diskspace in SQL Data compare SDK

Philn — Sat, 25 May 2013 00:02:57 GMT

Hi,
Is there an option to set in the SQL Data Compare API to place the temp files into a different path instead of the C:\ drive?
I am comparing a large databases with many tables and the default temp files are in C drive which I don't have much empty space.
Thanks

SQL Prompt versus SSMS 2012 intellisense

freecell1 — Fri, 24 May 2013 18:31:07 GMT

Hi folks -

I just installed SSMS 2012. I've been using SQL PRompt 5 with SSMS 2008 R2 until now and like it. However in SSMS 2012 Microsoft seems to have improved the internal intellisense. Also both the intellisense and SQL Prompt are on by default so I have two layered suggestion boxes popping up. Can someone clarify how SQL Prompt differs from the built-in offering?

Thanks,

John

sql prompt fails to format forceseek index hint (sql 2012)

gokhanvarol@gmail.com — Fri, 24 May 2013 16:00:59 GMT

SQL prompt fails to format below index hint, MSDN documentation is below.
This is a major problem now, I cannot use sqlprompt period for formatting since most of my scripts uses the forceseek hint.
Thank you

WITH ( FORCESEEK(1(CntyCd, PclId, PclSeqNbr)))

SELECT CONCAT(@D, k.AddrAptNbr, @D, k.AddrCarrt, @D, k.AddrDirLeftCd, @D, k.AddrDirRightCd, @D, k.AddrHse1Nbr, @D,
k.AddrHse2Nbr, @D, k.AddrModeCd, @D, k.AddrPfx1Cd, @D, k.AddrSfx1Cd, @D, k.AddrSfx2Cd, @D, k.AddrStreetName, @D,
LTRIM(k.AddrTypCd), @D, k.CbsaCd, @D, k.CensId, @D, LTRIM(k.CSZTypInd), @D, k.DPIDCd, @D, k.DpvCd, @D,
k.GeoMatchCd, @D, k.LatDegr, @D, k.LongDegr, @D, k.MatchCd, @D, k.OrigAddr1, @D, k.OrigAddr2, @D, k.OrigAddr3, @D,
k.OrigCityName, @D, k.OrigStCd, @D, k.StdAddr1, @D, k.StdHse1Nbr, @D, k.StdHse2Nbr, @D, k.StreetNamePfx, @D,
k.StdCityName, @D, k.StdStCd, @D, k.OrigZipCd, @D, k.StdZipCd)
FROM tTrans.TransSitus AS k WITH ( FORCESEEK(1(CntyCd, BatchDt, BatchSeq)))
WHERE k.CntyCd = @CntyCd
AND k.BatchDt = t.BatchDt
AND k.BatchSeq = t.BatchSeq
AND k.SitusSeq = 1

http://msdn.microsoft.com/en-us/library/ms187373.aspx

WITH ( <table_hint> [ [, ]...n ] )

<table_hint> ::=
[ NOEXPAND ] {
INDEX ( index_value [ ,...n ] ) | INDEX = ( index_value ) | FORCESEEK [( index_value ( index_column_name [ ,... ] ) ) ]
| FORCESCAN
| FORCESEEK
| HOLDLOCK
| NOLOCK
| NOWAIT
| PAGLOCK
| READCOMMITTED
| READCOMMITTEDLOCK
| READPAST
| READUNCOMMITTED
| REPEATABLEREAD
| ROWLOCK
| SERIALIZABLE
| SPATIAL_WINDOW_MAX_CELLS = integer
| TABLOCK
| TABLOCKX
| UPDLOCK
| XLOCK
}

Formatting cursor logic indents weird

Mindflux — Fri, 24 May 2013 15:20:21 GMT

Here's a kill user script I found on the web a long time ago, I've flattened it out to show what it looks like before SQL Prompt format

Code:

DECLARE @strSQL VARCHAR(255)

--PRINT 'Killing Users'
--PRINT '-----------------'
CREATE TABLE #tmpUsers (
spid INT,
eid INT,
STATUS VARCHAR(30),
loginname VARCHAR(50),
hostname VARCHAR(50),
blk INT,
dbname VARCHAR(50),
cmd VARCHAR(30),
request_id INT
)

INSERT INTO #tmpUsers
EXEC SP_WHO

DECLARE LoginCursor CURSOR READ_ONLY
FOR
SELECT spid,
dbname
FROM #tmpUsers
WHERE dbname = @dbname

DECLARE @spid VARCHAR(10)
DECLARE @dbname2 VARCHAR(40)

OPEN LoginCursor

FETCH NEXT
FROM LoginCursor
INTO @spid,
@dbname2

WHILE (@@fetch_status <> - 1)
BEGIN
IF (@@fetch_status <> - 2)
BEGIN
--PRINT 'Killing ' + @spid
SET @strSQL = 'KILL ' + @spid
EXEC (@strSQL)
END
FETCH NEXT
FROM LoginCursor
INTO @spid,
@dbname2
END

CLOSE LoginCursor

DEALLOCATE LoginCursor

DROP TABLE #tmpUsers
--PRINT 'Done'

Here's the same script after formatting it with SQL Prompt:

Code:

DECLARE @strSQL VARCHAR(255)

--PRINT 'Killing Users'
--PRINT '-----------------'
CREATE TABLE #tmpUsers
(
spid INT ,
eid INT ,
STATUS VARCHAR(30) ,
loginname VARCHAR(50) ,
hostname VARCHAR(50) ,
blk INT ,
dbname VARCHAR(50) ,
cmd VARCHAR(30) ,
request_id INT
)

INSERT INTO #tmpUsers
EXEC SP_WHO

DECLARE LoginCursor CURSOR READ_ONLY
FOR
SELECT spid ,
dbname
FROM #tmpUsers
WHERE dbname = @dbname

DECLARE @spid VARCHAR(10)
DECLARE @dbname2 VARCHAR(40)

OPEN LoginCursor

FETCH NEXT
FROM LoginCursor
INTO @spid, @dbname2

WHILE ( @@fetch_status <> -1 )
BEGIN
IF ( @@fetch_status <> -2 )
BEGIN
--PRINT 'Killing ' + @spid
SET @strSQL = 'KILL ' + @spid
EXEC (@strSQL)
END
FETCH NEXT
FROM LoginCursor
INTO @spid, @dbname2
END

CLOSE LoginCursor

DEALLOCATE LoginCursor

DROP TABLE #tmpUsers
--PRINT 'Done'

The "Fetch next" are the parts I find odd. Fetch Next gets indented away from FROM LoginCursor INTO ....

then the second fetch next before the END code gets formatted even further out, I guess because it's part of the indent logic for the WHILE BEGIN/END BLOCK?

RE: sql monitor alert level not changing down a level

priyasinha — Fri, 24 May 2013 14:44:06 GMT

My mistake Steven. I assumed that you are talking about built-in Fragmented indexes alert. I have received your email. Replying you in few minutes.

Thanks,
Priya

Changeset Comments Policy Error

flyer299 — Fri, 24 May 2013 14:26:11 GMT

I have Team Foundation server setup to require a Check In Comment on all check ins. I was excited to see that SQL Source was going to support this feature.

When we upgraded to the new version, even if we enter a comment we get an error.

"This Commit doesn't meet the server's policy requirements, or the policy isn't configured on your machince. The Server returned the follwing "Internal error in ChangeShet commetns Policy. Error loading the changeset comments Policy policy."

It does reference a CheckForComments.CS with instructions. Please help? We are dead in the water and can't check code in right now!

RE: sql monitor alert level not changing down a level

stevenhoban — Fri, 24 May 2013 13:45:09 GMT

ive got all the screen shots exce[t the 'frgmented indexe' tab - there isnt one !

Hopefully an easy question

jessay — Fri, 24 May 2013 13:39:40 GMT

Good morning all!

Resolved my issue which was unable to locate triggers pertaining to certain tables after decryption. Realized the code is just all tied to the table and I have to pull the trigger code specifically and then mail it off to the developer for review.