Viewing 15 posts - 76 through 90 (of 166 total)
You may want to check and see what the RAM usage is set to for SQL Server. In addition, 1GB is probably not enough RAM for a SQL Server INstallation...
December 21, 2005 at 5:51 am
I had to do this exact thing in the past. This is what I used:
SELECT SUBSTRING(URL,1,CHARINDEX('/',URL,8)-1)
FROM SITES
It took me a couple of attempts and a number of different filters which were...
December 20, 2005 at 12:53 pm
Probably the easiest way to do this would be to use the IDENTITY feature on the field you want to create a number for. This will produce a unique integer...
December 20, 2005 at 12:36 pm
The first thing I would check is whether the user belongs to a server level role which by default would have execute permissions, such as dbo, or sysadmin. Second, I...
December 19, 2005 at 1:37 pm
First thing I would try would be to run SP_UPDATESTATS on the database you just attached.
December 19, 2005 at 9:29 am
A good example of this would be a large update statement that takes a while to complete. If the server were to go down in the middle of the updates...
December 19, 2005 at 9:11 am
I definitly agree with what was said above. I would also try running a profile against the server to see long runnning code. Here is a link to a very...
December 16, 2005 at 12:41 pm
The reason your global table would remain is that if you created the table using query analyzer it would not be dropped until that analyzer session is closed.
December 16, 2005 at 10:03 am
Is the procedure creating a global or temporary table? In addition, take into account the following:
December 16, 2005 at 8:30 am
Here is a sample of the code I used to create a new File Group, a new file, and then add a table to that File Group.
ALTER DATABASE [DELTA2] ADD...
December 16, 2005 at 7:47 am
Executing jobs under the context of cmdexxe is limited to users of the sysadmin role by default. This can be changed by right clicking on the SQL Server Agent and...
December 13, 2005 at 12:40 pm
SQL Server 2005 does have support to enforce policies such as expiration date and so forth. However, I am unaware of such functionality in previous versions. I have have come...
December 9, 2005 at 9:38 am
I have not been able to find any documentation with that problem being associated to SP4. I have a similar setup on my pc and have never ran into any...
December 8, 2005 at 6:05 am
I'm not sure if this will work in SQL Server 7, but the way I do it in 2000 is:
SELECT TextData,NTUserName,HostName,ApplicationName,LoginName
FROM ::fn_trace_gettable(@TraceFile, default)
@TraceFile would be the physical location of the...
December 8, 2005 at 6:02 am
I would never recomend deleting anything from the system tables. The proper way to recover these jobs would be to restore the backup of the msdb database of the server...
December 7, 2005 at 12:01 pm
Viewing 15 posts - 76 through 90 (of 166 total)