Viewing 15 posts - 766 through 780 (of 789 total)
Apart from maybe using OLE automation scripts (which won't be all that much better) your sp_helptext method may be the most straightforward. Even tracing what actions the DTS copy...
June 9, 2003 at 7:51 pm
Just a shot in the dark, going back to your original question (BTW, if I have only ONE sheet in my excel workbook, named “tblExcel”, why do TWO sources appear...
June 9, 2003 at 4:06 pm
The "RAISERROR ... WITH LOG" will write to the SQL Error Log. This is viewable through QA with sp_readerrorlog or through EM under "Management / SQL Server Logs /...
June 9, 2003 at 3:42 pm
without researching it... I'd say yes, the change of collation will cause a problem.
June 9, 2003 at 2:20 am
Andy,
sysdtspackages isn't a system table in the same sense as system tables within master and model. Your can define triggers on them. Try the following for logging the...
June 9, 2003 at 2:17 am
The target server (on which master is to be restored) should ideally be at the same service level as the original. Further problems will be minimised by having SQL executables...
June 9, 2003 at 1:33 am
Leave the Identity field out of the Excel file... it's not needed.
In the DTS Import/Export wizard:
1. define your spreadsheet as source
2. define your SQL database as destination.
3. select "copy tables...
June 8, 2003 at 10:03 pm
Kevin,
When you say "I tried the "Collation" option, didn't help shown in one of the articles on the site.", can you elaborate? Did you get syntax problems, or did...
June 8, 2003 at 8:12 pm
No need to set passwords on databases.
Firstly, just remove the guest user from each of your databases to prevent people with valid SQL logins from snooping around in...
June 8, 2003 at 8:08 pm
I would suggest using profiler to capture, in the first instance, completion events for RPCs and Batches. Let it run for a good number of minutes (depending on the...
June 6, 2003 at 8:31 pm
-- Assuming, for simplicity sake, that your main table is defined like:
CREATE TABLE MainTable (
PKField INT PRIMARY KEY,
...
June 6, 2003 at 8:16 pm
This example uses pubs, but the idea's the same...
CREATE FUNCTION BookList
(@au_id id)
RETURNS VARCHAR(8000)
AS
BEGIN
DECLARE @Booklist VARCHAR(8000)
SELECT @Booklist...
June 6, 2003 at 3:05 pm
A Health Club client database on a 2gig Celeron? Sounds to me like you've overspec'ed the hardware. I run SQL on a 1.7big Celeron for all internal purposes,...
June 6, 2003 at 5:14 am
Cross,
It's you versus the bean counters. I can't tell you what to do, only what I'd do in the same situation.
For the low end scenario I would go for the...
June 6, 2003 at 4:11 am
You could use a BINARY value. Same storage requirements as INT but you can use all the bits. You may find it cumbersome though, depending on your processing...
June 6, 2003 at 3:46 am
Viewing 15 posts - 766 through 780 (of 789 total)