Error with simple maintenance plan
Sun, 23 Mar 2008 10:22:46 -0700 (PDT)
Team;
I've been getting nothing but errors recently; as I've been usign
maintenance plans.
Here is one of the error logs.
Executing the query "EXECUTE master.dbo.xp_delete_file
0,N'',N'',N'2008-03-14T00:56:18'
" failed with the following error: "Error executing extended stored
procedure: Invalid Paramet ...
|
How critical is the transaction log file?
Wed, 19 Mar 2008 22:01:00 -0700
For deployment purposes, our IT department has allowed us to send an mdf file
to 'attach' to their server in the interim until our own server gets built.
This development database that we're building does not have any 'user'
writes to the database, i.e. only DTS will add data to the database.
I've sent the ...
|
Error Dialog in SQL Server Management Studio
Wed, 19 Mar 2008 09:52:01 -0700
When I go to look at the securables in SQL Server Management Studio I get a
"Value does not fall within the expected range.(SqlMgmt)" dialog that comes
up. It seems to only do it on some groups. Anyone have a fix? ...
|
SSIS Import/Export Wizard and DTSWizard doesnâ??t works in SQL 2005
Wed, 19 Mar 2008 06:05:00 -0700
I tried to import a flat file into a SQL 2005 database using the SSIS wizard.
This wizard doesn't allow me to select the source (i.e. my â??flat-fileâ?). The
same happens when I using the DTSWizard tool. Is this an error in the wizard
or do I something wrong. ...
|
Management Studio and Schemas
Sat, 15 Mar 2008 14:47:16 +0100
Hello,
My database uses several schemas (catalogues).
How do I create a new table in schema other than default "dbo" using
Management Studio ?
If I specify a name like "myschema.testtable" saving a new table it creates
[dbo].[myschema.testtable].
Please advise,
Thomas
...
|
error in Sql Server import wizard
Fri, 14 Mar 2008 09:19:02 -0700
Hi
I receive an error when importing data from access to sql Server,
I googeled the errors but only found two things about it, One two sheck if
the datatype match in the access and in Sql Server and the other saying to
delete the local tempfiles.
the datatypes did match fine and I emty the local tempfile b ...
|
Job names for database maintenance plans
Thu, 13 Mar 2008 12:28:00 -0700
I've created several database maintenance plans and I create the schedule
within the database maintenance plan. This creates a job name the same as
the database maintenance plan name with the subplan name appended. When I
open up the job schedule properties within the database maintenance plans, it
default ...
|
|
|
How to run a DB shrink
Thu, 13 Mar 2008 04:31:01 -0700
Can anyone help me with how to run a DB shrink? How do I do it where do I run
it? ...
|
Cant install SQL Server Management Studio on XP
Thu, 13 Mar 2008 04:23:01 -0700
Good afternoon,
I've been trying to install SQL Server Management Studio on my laptop with
no luck. I am running windows xp professional sp 2. It continues to fail with
no clear message as to why. I have sql 2000 tools on this machine. Would that
break the install?
I get the message: The setup has encoun ...
|
Data mapping doesn't work with XML format file for bulk load.
Wed, 12 Mar 2008 08:22:28 -0700 (PDT)
It appears that XML format files for BCP are sensitive to the ordering
COLUMN entries in the XML file and that the Field ID mapping flat
doesn't work.
This problem with SQL Server 2005 is based on the [latest] BOL sample
"Using a Format File to Map Table Columnns to Data-File Fields". SQL
Server version 9.0.3 ...
|
