I am trying to create a linked server in SQL Server 2000 to Active directory using the following sql -
sp_addlinkedserver 'ADSI', 'Active Directory Service Interfaces', 'ADSDSOObject', 'ads...
Hi Experts,
I have installed SQL software to my PC. After I start the SQL server, what should I do in order to create a database ??? I guess my question is : where is the terminal (or ...
Hi,
I have an OLAp cube with dimension Dates having hierarchy levels:
[Dt year], [Dt Quarter], [Dt Month], [Dt Day No], the last one has as property [date key] which is the actual date (yyy/...
Does anybody know of a way to do this in SQL server (2000).
I want a query that returns the results of a subquery as a concatenanted string i.e.
table one contains:
ID | Item
======
...
Hello,
I need urgently to import some of the contents of a text file named VY_0002.txt into a SQL Server database table named ProcessData using DTS. The format of the text file data is as f...
I am trying to write a stored procedure that creates a pivot table without the aggregation. I have a database which stores test results for over 82,000 students which I normalized with hopes ...
I have to parse some data using OPENXML, the problem is that the XML may exceed the 8000 character limit of the TSQL varchar variable size. The documentation for sp_xml_preparedocument says it...
I have a DTS transformation step, with SQL Server as the source, and a text file as the destination. In my source, it is a global temporary table that is a single column called MyString varch...
I am trying to query a table in AS400, the date field in the AS400 is text(6). So when I try to query from Query analyzer I get the following error message.
Error converting data type DBTY...
I am checking the directory for existing files. I f the file exist then Main = DTSTaskExecResult_Success else I want the program to end. Main = DTSTaskExecResult_Failure will not work since ...
I am looking to create a UDF that converts a passed varchar(8000) to proper case, taking into account exceptions like MacDonald. I have a template UDF that works without any "exception handli...
Hi all experts!
I have a data table that holds some information with a date field as a char and formatted like '20040130'
I am trying to create a view based on the above table for a user who...
I have used the wizard to make a web page, I opted for the refresh on data change feature.
My web page however is only showing the data as at the time I used the web wizard. The data has chan...
ok so i created a MS SQL db , but now i cannot link to it.
I WOULD like to create a database in my C:/Cfusion/wwroot folder and not in ProgramFiles/MicsoSQL/Data folder.
Is that possibl...
Hi,
My database name is allen
today i saw mydatabase name : allen(suspect)
From error messages I understood that it is suspected because of not enough space.
I created more spaces.
W...
Dear all experts,
I'm living in Europe and I would like to know on how to convert a number to currency in Europe format . The format should be like this:
123456 -> 123.456,00
123...
I have a numeric date imported from AS400 in this format: 104125. It's actually the 125th day of 2004.
How do I convert this in MS SQL to a datetime format?
Thanks
I have a MS Access 2K front end and just switched to SQL Server 7 backend.
I imported the data from the prevous MSAccess backend and I had to set the primary keys and Identity fields in SQL...
I have a (I hope) simple question. When doing a full backup ( and the database is in full recovery mode) is it neccessary to backup the transaction log file in a seperate job for restore purpo...
When this code executes, the job is created, but I receive the following error message:
Server: Msg 14256, Level 16, State 1, Procedure sp_start_job, Line 38
Cannot start job 'DTS Pkg' (ID...
Hi,
My Project Backend is MS.SQL 7.0.
In a table there is one field amt_amount, type is Float, Lentgh is 8 and Prec is 53.
Now the problem is, in case of large value it is not coming in ...
Is there a way to programatically loop through columns in a table in t-sql.
I'm working on an accounting system and I have a table that has columns with different percentages that have to be ...
I used the command
bcp "Student.dbo.Student3" in C:Student.csv -fc:\Student.fmt -Scsm33068 -Usa
it then asks for my password but when I enter it it gives an error message:
SQLstate = ...
The TEMPDB Database on our server has been growing at an alarming rate. It gets up to 16 Gig some days before we get a chance to shrink it.
I've been told that complex SQL Queries and Comp...
Is it possible, i am sure it is. that i can us a combination of a getdate and datename within a query to be able to achaive a where command?
say that i have a query like this
Select col...
