Maintenance plan Setup
Wed, 28 May 2008 16:18:57 -0400
I am trying to setup a new maintenance plan that does nothing more than a
scheduled backup of a database. I am able to backup this database manually
from database\tasks\backup. When I execute the maintenance plan it fails
with the following error. I have looked in the log file and did not see a
time stamp as ...
|
KDC Error
Wed, 28 May 2008 08:52:02 -0700
I installed SQL 2005 on a domain controller and I am getting the following
error:
There are multiple accounts with name SQLSvc/Domain Name:1433 of type
DS_SERVICE_PRINCIPAL_NAME
I have run the following to try to determine the duplicate names but each
returned a blank text file indicating there are no du ...
|
SSMSE connecting remotely permissions question
Wed, 28 May 2008 16:46:39 +0100
Hi All
I am connecting remotely using SSMSE to a SSE on a W2003 server box using
WINDOWS authentication (NOT SQL Authentication)
This all works fine except I would like to know the "best" WINDOWS user
group for this user to be a member of ....
There is a local username on the server and notebook that ma ...
|
Importing data into tables
Mon, 26 May 2008 23:22:43 +0200
Hi,
I've a typical DB structure as follow:
Main table
Car_id
Make_id
Model_id
Color_id
And so on..
Make table
Make_id
MakeName
Model table
Model_id
Make_id
ModelName
And so on.
I'd like to import data to the mail table using .csv or .xls formats. My
q ...
|
Trigger - Stored Proc - Where to begin???
Fri, 23 May 2008 08:18:31 -0700 (PDT)
Hi all. I am brand new to SQLServer - and I mean brand new. I need
to find a way to test all student's records to find out if an
instructor_ID and name have changed in a student's record. If the
instructor has changed, I want to notify admin staff via email of the
old instructor ID and name and the new one. ...
|
plssssssssssssssss help
Thu, 22 May 2008 02:41:00 -0700
I have a job which being scheduled at the night time. after now a day im
facing a problem where my job fails. server is not restarted neither job is
being stopped. the error is as follows:
Executed as user: NT AUTHORITY\SYSTEM. Login failed for user 'NT
AUTHORITY\ANONYMOUS LOGON'. [SQLSTATE 28000] (Error 18 ...
|
Re: Parameter help
Wed, 21 May 2008 16:46:00 GMT
That was it.
Thanks
Hello Raymond D'Anjou,
> Is this what you want:
> select @param1 = value1, @param2 = value2, @param3 = value3 from table
> where
> UID = ID
> "Sean Bolster" <smbolster@gmail.com> wrote in message
> news:49c0a3379b558ca8945475b1038@news.easynews.com...
>
>> I had a questi ...
|
|
|
Parameter help
Wed, 21 May 2008 14:33:45 GMT
I had a questions about assigning values to parameters.
If I have say 3 parameters I wanted to fill from a table row what would be
the syntax.
@param1
@param2
@param3
I want to assign values with a query that will return 1 row like select value1,
value2, value3 from table where UID = ID
I tried s ...
|
Concurrency Help
Mon, 19 May 2008 22:11:37 -0600
As indicated by some other posts I made, I'm creating a table that maintains
the order of its items.
This requires adding a sort column. It also requires the following tasks:
1. When adding an item, I need to find the maximum sort value so far and
then store the new item with a sort value that is one highe ...
|
Truncate Transaction Logs
Mon, 19 May 2008 13:32:00 -0700
Hello Everyone,
I'm not exactly sure where to ask this question but I'm having a problem
with a few of my databases with there transaction logs growing too large.
I'm running SQL 2005, and all my databases are Full Recovery model. My
backups usually truncate the logs however they seemed to stop doing that ...
|
