Hello,
Can someone tell me where to download the client side activex control for the print button that was added with the new service pack?
Some pcs prompt for it automaticly, but others...
I have a SQL Server 2005 Express installed on my Intranet server that resides in my DMZ.
I have access from my LAN to my DMZ open.
I have the SQL Server configured to allow remote connec...
Ive lost my MS SQL Server disk and I need to use Enterprise Manager and other tools. Can you download these tools? I cant find anything on the MS site...
Hello, I'm a relative newbie to this since the SQL database person at my work is out for an extended period of time. Recently, on of the applications we use stopped working and returned the er...
Hey, I was wondering if there was a way in MS SQL (2000 specifically) to cast out a character, like in FoxPro
For example, in fox pro you could have
SubStr(alltrim(field), 1, at('$', al...
I am trying to write a new stored proc based off an exisiting one that counted the number of ads placed and inserted the data into a table. But now I want to break it down by class, so I am wo...
Hi Experrts,
I am having an issue with the correct syntax of the nested if then else in a stored procedure. I get a syntax error or access violation :code 0. please help!
CREATE PROCE...
Where can I find an entire list of the trappable SQL error codes? Is there a web site that contains a list of the error codes.
hell there,
i am having problem viewing reporting service reports i created.i get this error.how do i create a user with a trusted SQL Server connection.
the error i get is.but in my stu...
I'm looking to return a date format of DD:MM:YY in query analyzer and I keep getting the same format (YYYY:MM:DD)..
Here is my query: select convert(smalldatetime, getdate(), 1)
I also ...
Hi
How do you escape an american apostrophe (') to be input into a text field in MS SQL Server 2000
I don't have a choice but to use an actual apostrophe because this is for a language ...
Hello all,
Thank you for viewing this query. My query is as follows:
I have a SQL Server which was replicated from Server 1 to Server 2(as we want the website to be moved on to the 2nd s...
Dear all,
I know this question has been asked many times, but I still got the error after tried their solution.
I have MS sql Db table named [Testing] contains four rows and column
[my_...
How to do this:
select * from consent_properties where
(select streetaddress,count(con_consentid) as consents
from CONSENTS con, adults adl, CONSENT_PROPERTIES conprop, property_ids pids...
Hi, Experts:
Does SQL Server 2000 has any function or extended storeprocedures that has
the same functionality as Split() function in VBScript or Javascript? I try to split the
followi...
Hi,
While restoring the SQL serverdatabase, I obtain the following error:
Microsoft SQL DMO(ODBC: SQLstate 42000):
The backup of the system database on devise XXXX cannot be restored ...
Is it possible to call a stored procedure in a select statement
For example
SELECT Account_ID, Account_Number, Currency, (Exexute the stored procedure passing to it the Account_ID) AS Cu...
Hi
i have a set of datetimes records stored in a sql server database. i need to determine if any of these entries occured on the current day.
i have used both
select * from daily_inve...
Just quickie,
I need to return a string value based on data from a column.
For example, if data from a column contains "0" I need to return the string "Z", if it doesn't I need to return "...
I have a Windows SBS 2003 Server, Service Pack 2, 2gb ram and 200gb disk.
I have installed MS SQL Server 2000 with its latest Service Pack 4 and left in tact its standard "MSSQL Desktop Eng...
Hello,
We are new to MS SQL Server Management Studio and need to export a table to a csv formatted file. We figure there must be a wizard or some function to do this but have not found it....
Why won´t this work?
"Microsoft OLE DB Provider for SQL Server (0x80040E57)
String or binary data would be truncated."
To me it appears that it wont convert the Date to VarChar Datatype....
I need to update a field of a table that is itself used in the query to determine what to update. The only error I get out of SQL is a general syntax error.
UPDATE tblInvoice_Master SET tb...
I have a SQL database (SQL 2000) that has an Access2000 front end to it. Everything works ok for me, but for others it is not. When they click on the table or the report, they get "Connectio...
I feel really silly asking this question.
What is the formula for percentage? If I have a total of 1251 and sold 47 what is the percentage of tickets sold.
Thank you for not laughing to...
