Viewing 15 posts - 2,716 through 2,730 (of 3,232 total)
I prefer to backup to disk, then copy to tape or other media. Having the latest backup on disk will greatly increase your recovery time as you will not have...
July 28, 2006 at 8:58 am
"How can one investigate beforehand whether deleting the BUILTIN login off the server for security reasons may cause necessary applications logins to be blocked, etc."
Well, first of all you need...
July 28, 2006 at 8:54 am
OK Jan. The table DDL will help, but can you post a few lines of sample data from each table along with how you want the data to appear in...
July 28, 2006 at 8:43 am
Great analogy Joe. That's an easy way to get set based thinking accross to people.
July 27, 2006 at 3:35 pm
How about your table DDL? Can you post some sample data and what your data should look like after a sucessful run of your procedure?
July 27, 2006 at 2:03 pm
I see no way to do what you are asking. Since you cannot execute dynamic SQL inside a function, you have no way to return a value based on the...
July 27, 2006 at 11:38 am
No function needed. Even if you decide to put this into a function, you certainly do not need to use a cursor......
declare @name varchar(4000)
set @name = ''
select @Name = @Name...
July 27, 2006 at 10:23 am
Just curious, but can you give an example of how you plan to call/use the function?
July 27, 2006 at 9:11 am
Check the Windows Firewall on your new workstation. Disable the firewall and try connecting again.
July 27, 2006 at 8:49 am
Look up 'format files' in BOL. The section 'Using Format Files' will tell you how to set up a format file that tells BCP what the fixed length of each...
July 26, 2006 at 3:50 pm
UPDATE tbl_leads_queue
SET lead_status_id = 7
WHERE parent_lead_id = @LeadID
AND partner_id = 19
AND lead_status_id = 3
AND convert(varchar,date_sent,101) = convert(varchar, getdate(),101)
July 26, 2006 at 3:45 pm
Are you saying that you have nested cursors? I would say that the best way to avoid this problem is to avoid using cursors. If you post your code, you...
July 26, 2006 at 3:36 pm
Sorry to keep bombarding you, but check this out. You may be able to get back up without repairing/replacing your disk.
http://dis4ea.blogspot.com/2005/07/tempdb-and-missing-device.html
July 26, 2006 at 3:32 pm
Rebuilding your master database may get you going again. You may want to look into that option as well.
July 26, 2006 at 3:18 pm
Unless there is some magical way to make SQL Server look for the tempdb in a new location, you are down until you repair/replace the drive. SQL Server is looking for the...
July 26, 2006 at 3:14 pm
Viewing 15 posts - 2,716 through 2,730 (of 3,232 total)