Viewing 15 posts - 301 through 315 (of 617 total)
I would change the constraint to match the table. If you change the table you will have to change code to access them.
However you should still be...
May 11, 2011 at 11:59 am
A password for an FTP account still counts. You need to change your security level to EncryptSensativeWithPassword. When you go to type in the password hit the elipsys...
May 11, 2011 at 11:52 am
To simplify your error message I would change it so that you start out with a valid connection. That way when it does its verification at the beginning you...
May 11, 2011 at 9:50 am
Generally its a good idea to have an actual service account for SQL Agent just to be sure of your permissions. However I did notice something when I went...
May 11, 2011 at 9:39 am
Remote to the server
Start
All Programs
Microsoft Sql Server 2008
Configuration Tools
Open Sql Server Configuration Manager
SQL Server Services
Look at the row with SQL Server Agent (InstanceName), specifically the Log On As column. ...
May 10, 2011 at 1:45 pm
Can you log into the server as the Service account for your Agent and try to open the package? On several occasions I've changed things like the encryption level,...
May 10, 2011 at 1:17 pm
stormsentinelcammy (5/10/2011)
May 10, 2011 at 12:55 pm
stormsentinelcammy (5/10/2011)
May 10, 2011 at 10:33 am
Just because I always like to check the easy answers first, is C:\ORG\TEST.dtsx actually located on the server, or is it on your machine? One of the easiest mistakes...
May 10, 2011 at 9:47 am
Unless something has changed that I'm not aware of (more than possible), just because you have an index, even a clustered one, does not mean your data will come back...
May 10, 2011 at 9:38 am
How much free space do you have on your C drive? One of the first things SQL does is make sure its pre-reqs are there, including the correct version...
May 10, 2011 at 9:22 am
We would really need more information. Maybe an example of one of the tables (script the creation code), and an example of the alter code? And the exact...
May 10, 2011 at 9:20 am
parissa_bakhshi (5/1/2011)
?What do you mean by this? No issues in RAM, Disk,....
It should be noted that a lot of factors can affect your CPU usage. Including but not limited...
May 2, 2011 at 10:45 am
One possible solution to your problem (not how to regain your space, but how to rebuild your indexes if you don't have enough space) would be to create an additional...
May 2, 2011 at 10:33 am
I had a similar problem one time and although I won't guarantee that my solution will work for you here it is:
I created a new file/filegroup, then created a new...
May 2, 2011 at 10:21 am
Viewing 15 posts - 301 through 315 (of 617 total)