how to see active SQL Server connections?

Run below query and it will show you the dbname and number of connections SELECT     DB_NAME(dbid) as DatabaseName,     COUNT(dbid) as ...

Run below query and it will show you the dbname and number of connections

SELECT
    DB_NAME(dbid) as DatabaseName,
    COUNT(dbid) as NumberOfConnections,
    loginame as LoginName
FROM
    sys.sysprocesses
WHERE
    dbid > 0
GROUP BY
    dbid, loginame;


GetCoupon

Avail the best discount coupons for free. ... Check all website coupons/Offers/Discounts code aggregated from a list of diverse sources ...

Avail the best discount coupons for free. ... Check all website coupons/Offers/Discounts code aggregated from a list of diverse sources on the Web. ... compare against all leading online shopping sites....

Type your shopping site name and get all the coupons & offers. Enjoyyyy shoppppiiiinnnngggggg..





Export To PDF

public void ExportToPdf(DataTable myDataTable)     {         Document pdfDoc = new Document(PageSize.A4, 10, 10, 10, 10);         try  ...

public void ExportToPdf(DataTable myDataTable)
    {
        Document pdfDoc = new Document(PageSize.A4, 10, 10, 10, 10);
        try
        {
            PdfWriter.GetInstance(pdfDoc, System.Web.HttpContext.Current.Response.OutputStream);
            pdfDoc.Open();
            Font font8 = FontFactory.GetFont("ARIAL", 7);
            DataTable dt = myDataTable;
            DataRow toInsert = dt.NewRow();
            if (dt != null)
            {
                toInsert[0] = "Name";
                toInsert[1] = "Vehicle";
                toInsert[2] = "Location";
                toInsert[3] = "Customer";
                toInsert[4] = "Goods";
                toInsert[5] = "CreatedDate";
                dt.Rows.InsertAt(toInsert, 0);
                PdfPTable PdfTable = new PdfPTable(dt.Columns.Count);
                PdfPCell PdfPCell = null;
                for (int rows = 0; rows < dt.Rows.Count; rows++)
                {
                    for (int column = 0; column < dt.Columns.Count; column++)
                    {
                        PdfPCell = new PdfPCell(new Phrase(new Chunk(dt.Rows[rows][column].ToString(), font8)));
                        PdfTable.AddCell(PdfPCell);
                    }
                }
                PdfTable.SpacingBefore = 15f;
                pdfDoc.Add(PdfTable);
            }
            pdfDoc.Close();
            Response.ContentType = "application/pdf";
            Response.AddHeader("content-disposition", "attachment; filename= Consignment.pdf");
            System.Web.HttpContext.Current.Response.Write(pdfDoc);
            Response.Flush();
            Response.End();
           
        }
        catch (DocumentException de)
        {
            System.Web.HttpContext.Current.Response.Write(de.Message);
        }
        catch (IOException ioEx)
        {
            System.Web.HttpContext.Current.Response.Write(ioEx.Message);
        }
        catch (Exception ex)
        {
            System.Web.HttpContext.Current.Response.Write(ex.Message);
        }
    }

Powered by Blogger.