Viewing 15 posts - 46,441 through 46,455 (of 49,571 total)
Gordon (5/22/2008)
Understood, but I can see how one might wonder if instant file initialization makes use of sparse files...
Yup. Right now I'm wondering what could be going on.
Steven: Have you...
May 22, 2008 at 12:23 pm
Steve Jones - Editor (5/22/2008)
May 22, 2008 at 12:14 pm
Could you take a look see if you have any comebacks from my email also please? I'm not getting the newsletters but I do get the forum reply notifications. The...
May 22, 2008 at 12:12 pm
The system databases shouldn't be changing often, with the exception of distribution, which can always be recreated.
You shouldn't need to make frequent backups of them
May 22, 2008 at 11:57 am
All instant file initialisation means is that the OS doesn't zero out the file during allocation. It means that the file can be allocated with just some changes to the...
May 22, 2008 at 11:52 am
It mainly depends on the queries that use that table.
There have been a couple discussions on this the last few weeks. These 2 threads should get you started. If you...
May 22, 2008 at 11:47 am
I assume you're using object explore or registered servers then. The step/start/restart there uses the currently logged in windows user and net commands to do the requested operation. It doesn't...
May 22, 2008 at 11:17 am
aspirant.dba (5/22/2008)
When i executed Select statement against the Table, it took more than 25 mins to return the table.
If you tried to retrieve the entire table it's going to...
May 22, 2008 at 11:13 am
Generally for access violations you should contact Microsoft's Customer Support Services (formerly known as PSS) as they have much more chance of solving this than we do. It does cost,...
May 22, 2008 at 10:58 am
How are you restarting the service? (registered servers, object explorer, xp_cmdshell, shutdown)?
The user which am using is a SQL login and its not a domain user.
I'm not talking about...
May 22, 2008 at 6:36 am
Ratheesh.K.Nair (5/22/2008)
I tried using a new login with only datareader and datawriter database roles and access to only one DB.
Not what I asked.
May 22, 2008 at 5:56 am
you can use exec, since you're not passing parameters in or out of the dynamic SQL
CREATE procedure Search
(
@SearchKeyword Varchar(2000),
@Productid varchar(2000),
@Type varchar(200),
@SQLPerms varchar(5000)
)
as
Declare @sql varchar(7000)
set @sql=' This Statement length goes...
May 22, 2008 at 5:50 am
How are you restarting it?
Are you a domain/local administrator on the server?
May 22, 2008 at 5:27 am
Please rather post SQL 7 related questions in the SQL 7 and 2000 forum, rather than the SQL 2005 forum. Here you're going to get a lot of suggestions for...
May 22, 2008 at 5:12 am
Sounds like you may have hit a bug.
What's your version, edition and OS? Can you zip and attach the text file that the dump creates to a post please?
May 22, 2008 at 12:24 am
Viewing 15 posts - 46,441 through 46,455 (of 49,571 total)