Viewing 15 posts - 331 through 345 (of 469 total)
Once you create the SSIS package, save it to the folder path Microsft SQL Server-->90-->DTS-->Packages-->Your Package Name.
To run this as a job..create a new job and when you create the...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
November 11, 2008 at 6:24 pm
I recently installed SP3 on an A/P cluster. The build is 4028. Its working fine for the moment, would like to know if there are any issues...
Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
November 11, 2008 at 6:17 pm
What version of SQL are you using? As Manu suggested check for jobs in the management folder in SQL 2000 and under SQL Servre Agent for SQL 2005.
Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
November 11, 2008 at 5:57 pm
Guys, SQL 2005 SP3 has rolled out. I have upgraded my Server to SP3 as I was experiencing an issue with SP2. Are there any known issues with SP3 till...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
November 11, 2008 at 5:55 pm
AD and SQl get preferences alike if its a Mixed mode authentication. To be certain that it is not a permission issue I would suggest to use the SQL login...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
November 10, 2008 at 3:07 pm
Once the transaction is completed is the session still running, if so try closing the session out.
Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
November 10, 2008 at 12:51 pm
Do this before you try to run the reset status statement..
USE master
GO
...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
November 10, 2008 at 12:49 pm
make him the ddlAdmin. And revoke the permission once he adds the column to it.
Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
November 10, 2008 at 12:46 pm
What error does the user get when he tries adding a column from the Management Studio??
Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
November 10, 2008 at 12:40 pm
Check in the error logs. What does it say for this database name. Is the disk that holds the data files for this online? How about the log files?
Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
November 10, 2008 at 12:36 pm
If this is a new instance, did you install it as a Named instance?
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
November 10, 2008 at 8:35 am
Migrate the DB and then run sp_revlogin to transfer the logins.
As Earl said, you need to change the owner of the schemas to dbo and then delete the obsolete logins....
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
November 10, 2008 at 7:50 am
Does anyone know if this calls for re-installation of SQL server or is there any hotfix for such an issue, because the server is on SP2 at this time. The...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
November 10, 2008 at 7:47 am
You can upload a picture in jpg or any other format as an attachment. The link for attachment is at the very end when you are replying to a post.
Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
November 10, 2008 at 7:44 am
LOGICAL FRAGMENTATION:-It is the level of fragmentation in your leaf nodes. Why does this happen?
The reason is when ever you insert or delete a row from your table the indexes...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
November 7, 2008 at 1:04 pm
Viewing 15 posts - 331 through 345 (of 469 total)