Viewing 15 posts - 9,136 through 9,150 (of 9,244 total)
avipenina (7/21/2008)
so i write this syntax and i get an error.why?THX
this should do it
if not exists (select name from sys.configurations where name = 'xp_cmdshell' and value_in_use = 1)
begin
EXEC sp_configure 'show...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 21, 2008 at 3:05 pm
follow these steps
move the MASTER DB first. Stop the sql instance and agent and copy the database files
(master, model, tempdb, msdb, mssqlsystemresource and dist DB files) to their new...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 21, 2008 at 12:59 pm
check the NTFS file permissions on the data files
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 21, 2008 at 12:52 pm
G.R.Preethiviraj Kulasingham (7/21/2008)
Do you have SSIS packages stored in the database?What about the scheduled jobs?
Do you have replication in that server?
as above
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 21, 2008 at 12:51 pm
Michelle Potts (7/21/2008)
The new server will...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 21, 2008 at 9:48 am
Johannsky (7/20/2008)
I am using the default backup tool of SQL Server 2005. I run the backup using job.
having you considered something like Redgate SQLBackup or Quest Litespeed?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 21, 2008 at 5:16 am
if you have underlying hardware RAID leave the windows disk types as Basic, you do not want or need dynamic disks.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 21, 2008 at 5:13 am
is the hardware the same on both machines?
you could use symantec GHOST
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 20, 2008 at 2:09 am
why not use one of the built in templates. checl BOL for the template details
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 20, 2008 at 2:08 am
i would check the folder and then the file permissions on the folders the log and data files reside in and the database files themselves, that will undoubtedly be the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 20, 2008 at 2:06 am
New Commer (7/3/2008)
i have a query like this,
Select Distinct Table1.name, Table1.Code, Table2.Place, Table2.Marks From Table1 inner join Table2 on Table1.code = Table2.code
which results,
Name1/N1/Nagpur/114
Name1/N1/Nagpur/154
Name1/N1/Nagpur/123
i want it to display as
Name1/N1/Nagpur/114
...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 20, 2008 at 1:56 am
gbargsley (7/18/2008)
I am in the process of cleaning up some database records. This is a yearly purge type of process for my software application.
As it sits, my SQL DB...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 20, 2008 at 1:43 am
You dont mention how big the disks are but i would opt for a RAID1 config on both drives and install everything to the 1 logical drive.
If the drives...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 20, 2008 at 1:31 am
from memory i'm certain the cluster name is published into AD, search AD for the cluster name and check the container it is in
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 20, 2008 at 1:18 am
On the production servers i have migrated there have always been a substantial amount of windows\sql user logins that have a default database set. Just the way i prefer to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 20, 2008 at 1:01 am
Viewing 15 posts - 9,136 through 9,150 (of 9,244 total)