Dear All, Hi I am using below given procedure to send SMS from Ms-SQL. it's working fine till yesterday night. But, today I am getting following...
Dear All, I am looking for a solution without compromising on Performance & without writing all column names to get all rows those have NULL or...
Dear All, Hi! I am searching a solution to PIVOT more than one column to get output in below mentioned format. I have a table which has data in...
Dear All, Hi! I have a DB which has many tables, views, SPs, Functions, Triggers etc. Now, In many of them I have used fully qualified name (i.e....
Dear All, Hi! I am searching a solution to log all the rows those are not inserted in a table due to failure in passing Primary and/or any UNIQUE...
As we know that we can insert data from XML into SQL Server 2008 tables. I have 2 questions related to data insert from XML: - 1. Can we insert...
Dear All, I have implemented the Log shipping manually on my servers & the same is running without any error. I have a question related to LOG...
Dear All, I have implemented MANUAL Log Shipping on SQL Server 2008. Here, Manual means First I took the full backup of a DB then Restore it with...
Dear All, Hi! I have an online application, which uses ms-sql 2005 database as back-end. In this application lots of Entry forms & reports are...
Dear All, Hi ! I need a MS-SQL QUERY based solution to Export an Image or PDF file into Remote SQL Server Database table from local machine. For...
Dear All, I know that by default Microsoft SQL creates Clustered Indexes on Primary Key fields of a table & if some performance issue is there to...
I have a table by name tbl_trPurchaseClear. Structure of this table is given below. It stores all the records related with Purchase deals & have...
Dear All, Hi! I need a MS-SQL QUERY based solution (without using xp_CmdShell) to check that given file name (for ex.: - 123.jpg) is exists on...
I have a table named "tbl_test" with an identity column called PKEY. I have more than 200000 records in this table. I need to clear this table &...
Dear All, Hi ! I require a MSSQL query to generate Random Number SERIES from 1 to 30 numbers (not only a single random number but a series) in a...
Dear all, Hello ! I am in a need to link an Excel file with a MSSQL table or vice versa. It means that when a user make some changes or insert new...
I have a table in MSSQL2005 database which collects employee salary data. After every month I need to check how many employees are there whose...
Hi ! I created a user in MS-SQL 2005 & need to hide this user from Enterprise Manager as well as from Management Studio. So, that no one can delete...
Hi! I have 2 SQL Servers those are used for different purposes (Both Server SQL Login credentials are with me). I am writing a Store Procedure on 1...
Hi ! I am in a need of generating Unique Random Numbers between given Number Range. For Example, a user provides a Number Range between 1 and 50. So,...
Separate names with a comma.
