Viewing 15 posts - 6,556 through 6,570 (of 7,191 total)
February 9, 2007 at 3:39 am
Alex
That behaviour is typical of SQL Server. It grabs all the memory it can and only gives it back if another process requires it. If you find that there's contention...
February 9, 2007 at 1:55 am
Could it be that you have a case-sensitive collation, so that when you do SELECT * FROM sysobjects WHERE name = 'MYTABLE' and xtype = 'U', it doesn't return anything...
February 7, 2007 at 10:10 am
SELECT
[name]
,[enabled]
,[description]
FROM [msdb].[dbo].[sysjobs]
February 7, 2007 at 9:31 am
This should do it for you.
UPDATE PRODDTA.F0911
SET [GLREG#] = 0
WHERE GLLT = 'AA' AND GLPN = 12
AND GLCTRY = 20 AND GLFY = 5
The reason your update...
February 7, 2007 at 9:20 am
Imke
This query returns the data and log size for all databases on the server, right? But it only provides a snapshot of the sizes at the time the query is...
February 7, 2007 at 8:09 am
Do you really need to shrink at all? It sounds like you have plenty of disk space... are you doing this to free up space for something else? If not,...
February 7, 2007 at 3:06 am
Yes. That one looks a bit scary. It should be possible to write it without dynamic SQL, though. And using joins instead of subqueries, where you can, will make it...
February 6, 2007 at 8:09 am
Frances
It's in the last line - did you mean to say @quiz IS NULL or @quiz = ''?
John
February 6, 2007 at 7:59 am
Andy
Surely not if that involves dropping and recreating publications, or hacking system tables? Backup and restore requires neither of those.
John
February 5, 2007 at 8:33 am
Andy
Why not just back up the database and restore it to the new location? You don't have to touch the system tables then.
John
February 5, 2007 at 2:12 am
Yes, you can do that using replication, but I can't think why you would want to. Perhaps you could explain a bit more about what you (or your boss) are...
February 2, 2007 at 5:09 am
You can use bcp or DTS. There is lots of information about them in Books Online.
John
February 2, 2007 at 3:50 am
Please will you give the text of the error since the picture you posted is only visible to you.
Thanks
John
February 2, 2007 at 3:49 am
If you have one application and one database then you can't have active-active clustering. Active-active involves having two instances or more set up, with those instances running on different nodes...
February 2, 2007 at 3:21 am
Viewing 15 posts - 6,556 through 6,570 (of 7,191 total)