Viewing 15 posts - 1,546 through 1,560 (of 1,883 total)
I just wanted to add to my question that I have no problems doing exactly the same thing on Windows 2000 Server with IIS 5. It is just on Windows...
May 3, 2005 at 2:45 pm
Hello,
Did you check if it is a data storage issue or presentation issue? I mean, did you use Query Analyzer to select from sysobjects?
select
crdate
May 3, 2005 at 10:06 am
I am running Developer Edition Beta 2. No such configuration option.
Yelena
May 3, 2005 at 9:53 am
I agree with Peter. I answered "correctly", but I don't really agree with the "correct" answer. The reports may vary by the CPU and Memory used. It could be 100...
May 3, 2005 at 9:15 am
Hi Joe,
This message is most probably Firewall. Please ask your infrastructure support to verify that the Firewall is open from your IP address. They usually open it from a particual...
May 2, 2005 at 4:24 pm
Saulo,
When you use DTS you first fill out the Wizard, then click Run Immediately on the last page of the Wizard, then it says: "Create Table" (if you DTS into new...
May 2, 2005 at 4:10 pm
Hi,
The original question was not clear, do you want to share across profiles on one server (this could be guessed by the topic title) or you would like to...
April 29, 2005 at 4:23 pm
Heather,
Backup and Restore or Detach/Attach are the safest ways agree with all other opinions
Here are 2 things to watch if you are using different techniques:
- If you use DTS Import...
April 27, 2005 at 12:25 pm
Hi,
I am not sure it will work accross different servers but try this:
Suppose all your registered servers are in one group SQL Server Group (if not, adjust accordingly)
Export a registry...
April 27, 2005 at 11:31 am
I don't think Select Into configures indexes and keys.
You may want to script the table first with all keys and indexes but WITHOUT Drop Table option so you would not...
April 11, 2005 at 2:04 pm
Steve,
May it be that their log file is with no growth? I am not sure at what point the destination database options are overwritten with the database-to-be-restored options.
You may want...
April 11, 2005 at 11:18 am
While we do get "With Move" errors when using different paths on the source and destination servers when not changing locations appropriately I don't remember seeing errors related to Expanding...
April 11, 2005 at 10:04 am
For example you may use an ASP page that queries MSDB connected as a read-only user for MSDB. The script should query sysjobs and sysjobhistory and return a job name, step name...
April 5, 2005 at 4:33 pm
I think that what DBA should be watching is what the developers are up to in between watching the Red Sox games.
All other time should be dedicated to writing scripts according...
April 4, 2005 at 2:00 pm
Totally agree. Just had a similar task. I used multiplying by 1.00 and then used Convert to make the output look nice for the report
Convert(decimal(7,3),Orders*1.00/mytotal)
Yelena
April 4, 2005 at 10:34 am
Viewing 15 posts - 1,546 through 1,560 (of 1,883 total)