Viewing 15 posts - 136 through 150 (of 222 total)
try checking the front end config file. could be a problem with login credentials there.
also is the user who is trying to connect a windows domain user. check if...
October 19, 2008 at 10:38 pm
check out the link, think this is what you are after
http://www.kodyaz.com/articles/kill-all-processes-of-a-database.aspx
October 19, 2008 at 9:46 pm
sanya.ibrahim (10/19/2008)
I have a Db in MSSQL2005. Some of the machines running the front end are stand alone and so have their own sql db. I want to...
October 19, 2008 at 8:50 pm
if sql server was installed successfully, then rebooting of machine is required. I have experienced the same problem and reboot was the solution to it. Hope it works for you...
October 19, 2008 at 8:37 pm
finally, i got it. yeah... 🙂
i took help of ssis to load this huge file. was amazed to see the power of ssis. just took 3 mins to load 150...
September 16, 2008 at 11:32 pm
Hi Jack
I am not good at SSIS specially playing with XML Files. I tried using XML task but was unable to capture the data from xml file as the file...
September 16, 2008 at 7:39 am
You can export the data using Import Export Wizard and have the table joining query as source and export it to a csv file. Other option is to use BCP...
September 10, 2008 at 12:44 am
Hi josetur12
I cannot just delete the duplicates because they are not really duplicates.
So, what I need to do is add a suffix to each duplicate value.
you said that these...
September 9, 2008 at 7:31 pm
SELECT
[name] + ', '
FROM sys.columns
WHERE [object_id] = object_id('TableName')
ORDER BY 1
The query above will return extra comma ',' between last column name and...
September 5, 2008 at 12:29 am
if your intentions are only to export results of query to text file, why don't you use SQL Server Import Export Wizard or BCP. Using either of these two will...
September 5, 2008 at 12:05 am
sanuj (9/4/2008)
7.0.23.0. I want to update the last 0 with 4 using substring. How to do ?:hehe:
could be a better way to do it but this thing just triggered in...
September 4, 2008 at 11:13 pm
import the txt file into excel through import data option. select the column delimeter as tab and save it is as excel worksheet. now import the data into sql server...
August 26, 2008 at 6:37 am
Nuts (8/21/2008)
I have got a column in my table which is enclosed in the double quotes. I need to remove these quotes from the entire column. How do I...
August 21, 2008 at 10:02 pm
I do put the semicolon after every statement now though .... it is mandatory with some statements (or combinations of statements)
Hi Matt
Can you please give me example of...
August 20, 2008 at 12:03 am
Prachin, why don't you use BCP command where you can execute your query and the results would be stored in text file. There you can also specify whether you want...
August 19, 2008 at 11:59 pm
Viewing 15 posts - 136 through 150 (of 222 total)