Viewing 15 posts - 2,911 through 2,925 (of 3,738 total)
Lucky9 (5/26/2011)
Create Table Status
( ID int Identity(1,1),
ClientID int,
StatusStartDate Datetime,
Status Int)
Insert into Table Status(ClientID,StatusStartdate,Status)
Values(100,'2010-01-28',1)
Insert into Table Status(ClientID,StatusStartdate,Status)
Values(100,'2010-03-20',1)
Insert into Table Status(ClientID,StatusStartdate,Status)
Values(100,'2010-05-30',2)
Insert into Table...
May 26, 2011 at 10:12 pm
Sounds like the SQLAgent Account does not have permissions to open the Excel file.
Check permissions.
May 26, 2011 at 11:21 am
dunne.neal (5/26/2011)
Elliott Whitlow (5/26/2011)
Just add a login in SQL with your domain\user and add it to the sysadmin server role. Done.CEWII
i tried but dont have access to do it
How...
May 26, 2011 at 11:15 am
Elliott,
I did not know that this issue was addressed in 2008.
Unfortunately I would assume that they could still stop the services and accidently wack or move the Data files, etc.
Thanks.:-)
May 26, 2011 at 10:10 am
Elliott Whitlow (5/26/2011)
On a local machine I could go for that. On a server, nope, I would prefer the OS admins NOT have access to SQL..CEWII
I agree but usually...
May 26, 2011 at 10:03 am
dunne.neal (5/26/2011)
I want to give myself (my ntlogin) sysadmin rights on my local host
Another Option to adding you to the Fixed Server Role would be to add you as an...
May 26, 2011 at 9:38 am
That is true but what is the datatype in the column of F54?
As was previously requested. please state what you are trying to do?
DECLARE @F54 Decimal (14,4)
SET @F54 =...
May 25, 2011 at 10:39 am
Krasavita (5/25/2011)
When I run this for data:1668541.0023
get error:overwflowed int column
The following works?
DECLARE @F54 AS int
SET @F54 = 1668541.0023
SELECT CAST(REPLACE(@F54, '.', '') AS int)
-----------
1668541
(1 row(s) affected)
What is the Datatype of...
May 25, 2011 at 10:16 am
Why do the developers need access to your Production Systems?
The following article addresses some security concerns of LINQ:
http://blog.statusnotquo.com/2011/04/11/security-considerations-for-linq-to-sql/
May 25, 2011 at 9:57 am
Please provide the DDL for the table.
May 25, 2011 at 9:21 am
Where is the second table that you are Joining on?
You need to add an alias to each column.
May 25, 2011 at 8:50 am
Use an alias on each table that you are joining?
May 25, 2011 at 8:43 am
You may want to provide some additional information.
Try using an alias on each table and each column?
May 25, 2011 at 8:43 am
gary.mazzone (5/25/2011)
I only showed a peice of what I am doing this is the whole query:
Did you have a question?
May 25, 2011 at 8:39 am
It sounds like you have a typo on your syntax.
May 25, 2011 at 8:30 am
Viewing 15 posts - 2,911 through 2,925 (of 3,738 total)