Forum Replies Created
Viewing 15 posts - 256 through 270 (of 327 total)
-
RE: Changing a columun Transaction Replication
Look at this article. I think it may help you.
http://www.sqlservercentral.com/columnists/pibison/alteringacolumnonareplicatedtable.asp
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: copy and paste database
What version of SQL are the files from? If they are from 2000 and you are attaching to 7.0, you would get this message.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: Line width is too long in many of your articles
Maybe I'm being a little 'dim', but what can I, as the reader, do to make viewing the article easier? I found that the 'Print This' helps but not always....
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: Move Databases between different Servers
If I understand correctly, you want to transfer users of a database with corresponding passwords. Passwords are stored with the login. The Transfer Logins task in DTS can be used and it...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: Forecasting
The RK folder isn't in the path. The easy way around it is to copy srvinfo.exe to the Windows folder.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: Forecasting
I have a stored procedure that executes a cmdshell and pulls in the data from srvinfo (from W2K Resource Kit). It parses it for just the drive info and stores...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: SP4 AWE Hotfix
100+ servers - no problems.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: Forecasting
Do you need to produce a report on space usage for all servers periodically or a notification when a server reaches a configured threshold (i.e. drive E at 80 % of...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: Smart Tabs in Query Editor
Don't feel bad - you're not alone.
I think there are some at MS that take absolute delight in confounding us.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: Scheduling Backups
Schedule backups - creating a maintenance plan in SSIS (SQL Server Business Intelligence Studio on the menu) might be the easiest way.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: Differential Backup one file lost
Since you are appending only the day of the week, yes, the file will be overwritten each time it is run on the same day.
Will you break the back...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: Restore from large database backup
You can speed it up a bit more by "striping" the backup. Break up the backup file into 4 files so that each one is approximately 1GB. SQL will create...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: Help! Need to append rows daily to an existing Excel sheet.
I'm getting an error :
Invalid column name 'columnname1'
Any idea?
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: Help! Need to append rows daily to an existing Excel sheet.
thanks - I'll give this try a little later. I'm much more comfortable with QA than ActiveX
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: Veritas Backup
I have agree with J.T. In my experience with 3 major tape vendors, not one could provide the reliability I have needed to meet SLAs for recovery.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
Viewing 15 posts - 256 through 270 (of 327 total)