Viewing 11 posts - 436 through 446 (of 446 total)
Not worked with migrating 7 to 2005. But this blog article did help me lot from 2000 to 2005. I think the issue would be more or less...
January 4, 2008 at 10:41 am
As Matt said check sp_rename in BOl..
sp_rename [ @objname = ] 'object_name' ,
[ @newname = ] 'new_name'
[ , [ @objtype...
January 4, 2008 at 10:00 am
Check this link.
Also try changing the name of the sheet1$ or just put one sheet instead of 3 and check when you are executing the excel file is...
January 4, 2008 at 9:54 am
Try this. Its working good for me. Create this proc in you current database.
CREATE PROCEDURE sp_get_script @name sysname
exec master.dbo.xp_get_script @name
January 4, 2008 at 9:39 am
Shared memory - TSQL LocalMachine
Named Pipes - ...
December 28, 2007 at 8:29 am
It would have been a good humor when all the answers had got 5 points.;)
December 26, 2007 at 9:06 am
Great job Steve. Overall look is good and new format is more flexible than before but must say that searching scripts was more good in previous version. It...
September 24, 2007 at 10:10 am
I am not able to download csv file. Give me invalid page error. Am I only getting this error or everyone.
April 23, 2007 at 3:07 pm
What account did you select to run your services for new instance? Is this instance installed on a domain machine? If you have selected local system account while installing...
April 9, 2007 at 3:51 pm
Good informative article. thanks. But one question, how do you send files to ftp server. Can we create a batch file (or may be different approach) to send backup...
January 3, 2007 at 10:15 am
select objectid, indexid, sum(*) as scans
group by objectid, indexid
what is sum(*) here? it should be sum of some column name, right?
August 30, 2006 at 2:39 pm