Viewing 10 posts - 31 through 40 (of 40 total)
Agreed, you can alter the a database but not the server default.
Just make sure you run the command in master! Otherwise, you get an error message.
July 6, 2005 at 8:28 am
Why use a temp table or view? Just use the bcp query out like this
bcp.exe "select CustomerID, CompanyName From master..Customers" queryout C:\Data\Customers.txt -S %isqlserver% -U %isqluser% -P %password% -c >>C:\DATA\LOG\customet_bcp.log
July 6, 2005 at 8:18 am
Why not ftp the files from the Sybase server to MSSQL server?
Or, use DTS to connect and have it pull your data for you?
July 5, 2005 at 12:02 pm
Although I have never used the -o switch, I do run a similar batch update.
Within the batch file I log the results to *.log to provide an audit trail.
May 18, 2005 at 9:48 am
Yes that is quite odd. I just ran it under the pubs db on my test server and here is the result. I removed the collation just to reduce the...
May 12, 2005 at 8:17 am
Kudos for using the information schema provided by SQL server. I see your point about the provided script and that it maybe confusing. However, it is a example and can be...
May 11, 2005 at 8:15 am
I have used this myself. I'm no not recall where I picked it up from but, it is very helpful. Use it in Query Analyser and just cut and paste...
May 5, 2005 at 10:10 am
I may not have used the term 'honking'. But, yes legacy data is a generic term for information that has been accumulated in a system that is beign replaced or...
May 5, 2005 at 10:04 am
I just installed two new servers that handle mulptile database that are accessed by different front ends. Here are the specs:
HP Proliant DL380G3 Dual Xeon 3.06 GHz<O
April 21, 2005 at 8:13 am
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'foo'.
Clearly the table name is invalid.......and should be People
If the query had been correctly coded as:
SELECT TOP 1 WITH...
October 14, 2004 at 7:01 am