Viewing 15 posts - 286 through 300 (of 347 total)
There is no column job_id located in msdb..sysdatabases. I think you might want to change that to sysjobs table if you are trying to find out the job name...
November 24, 2003 at 12:10 pm
The best way to export logins is bcp out from master..syslogin to a text file and then go to that file to remove the line for
sa, repl_subscriber and repl_publisher.
Once you...
November 24, 2003 at 11:42 am
It would be inconsistent for the time being, but going forward would be a good practice. We just got to break the bad habbit. I keep my log...
November 21, 2003 at 9:52 am
msdb database, I had to hack it by going into sysjobs and update the sysjobs so that it point to local or the new name. It not that bad...
November 20, 2003 at 2:12 pm
You could leave your current one the way they are and set up the correct path for the future databases. We did have a server that has different drive...
November 20, 2003 at 2:05 pm
I forgot to address the log and data problem.
Once you detach the database you have to go to the database file for .mdf and .ldf and move it to the...
November 20, 2003 at 12:57 pm
you can not change the directory of an existing database. You would have to detach and re-attach those database to get move it to different folder. Because you...
November 20, 2003 at 12:55 pm
we typically set up our data seperate from our log.
Start Enterprise Manager-> Server -> right click properties->database settings ->Default Data directory: D:\SQL\DATA
Default Log Directory: E:\SQL\DATA
everytime you...
November 20, 2003 at 11:57 am
It's been a while since we replace sql 7 but I think you have run set up for sql 7 again to get the server you rename to work. ...
November 20, 2003 at 11:50 am
why do we have to go arround so much when you don't want that column, just do
select a, b, c , d from tablez
instead of
select * from...
November 20, 2003 at 9:46 am
I don't think the security team need to add or remove login. User could be removed from any database by database owner or security admin withing that database, but...
November 20, 2003 at 9:38 am
the user that you want to change the sql service account need to be a user at a minimum at your local box.
mom
November 20, 2003 at 9:22 am
In my opinion, only use cursor as the last resort because it takes more time and more resource.
you could also parse out your update such as
declare @a int, @i int
set...
November 19, 2003 at 12:13 pm
You just need to be dbo to add user to a role.
mom
November 19, 2003 at 11:54 am
Have you try just to insert to a table with 1 column of identity and 1 column of data.
Once you got it into the database you could parse and look...
November 18, 2003 at 9:41 am
Viewing 15 posts - 286 through 300 (of 347 total)