Hey, I just found out about this event where millions of people around the world are joining together to make a statement about climate change by turning their...
Hi All, I am trying to fix the issue with xp_sendmail from DTS package.and it is not working, we are using outlook. I am running SQL 2000 server with sp 1. ...
Hi, I guess you might not have permissions, check them. Arsalan http://mvp.support.microsoft.com/profile/Arsalan http://dotnetolympians.wordpress.com ... ...
I am having a query . I want to know how to build business intelligence tools using sqlserver 2005 and visual studio developer 2005. Please give me some basic...
Hi All, what are the different ways to debug the stored procedure?? Is there any way to debug a stored procedure through Sql server management studio?? -- ...
in sql 2005, debugger in not directly included.. you would need to use visual studio for that.. here are the link that you can use for more information. ...
http://www.microsoft.com/sql/solutions/bi/default.mspx Above is the link, you should use to start marching ahead with BI.. if you need any particluar...
Sever issues with CDONTS. Here is a KB http://support.microsoft.com/kb/870675 Sandeep Chanda From: sqlcon@yahoogroups.com [mailto:sqlcon@yahoogroups.com] On...
1. Click Start, and then click Enterprise Manager. 2. Expand Microsoft SQL Servers. 3. Expand a server group, expand a server, and then expand Support...
MUGH Session (Community Launch [VS 2008/ SQL 2008/ Windows Server 2008] - Part 3 Venue : Prayas hall,Learning center II, Phase II, Infotech Premises, Hi-tech...
Hi All, We have already established logshipping and both are working fine.... Steps we have done on the primary server ... 1. Added one log file on H drive ...
You will need to resote full database backup on secondory location if H drive does not exists. Read more in below MS article. In a SQL Server 2000 Log Shipping...
Hi Guys, Have some one ever heared of using Squids for SQL Server? I was trying to get some details on it all I see them is some sort of proxies that are used...
I had heard about it from some projects... will get back to you JJ NDA LLL Thanks and Regards Veer Ji Wangoo Senior Manager Service Delivery Microsoft MVP ,...
Hi All, Please help me out... exec xp_dirtree xp_cmdshell I want to read all the .sql files from a folder. need to write a procedure and will send folder path...
Hi All, Now am able to get the files into a table from a folder. Please help me out how to execute a .sql file from a stored procedure and error need to...
Once you get all the filename to a table using XP_CMDSHELL 'Dir' command loop through this table and use dynamic sql with SQLCMD -i option to run the file. ...
Login into the www.stanacard.com to make International Phone Call?.. Use Pramotion code:- 149700 Logged in today and get the benefit.. get double talk...
Hello DBA group, While trying to execute a stored procedure I am getting error that 'SELECT permission denied on table .......' The DBA has given execute...
Hi Team, Could you please let me know what are the key changes required in stored procedure / functions /triggers/default while migrating project from 2000 to ...
Hi, I have received a sample XML from my provider which I need to parse and then save these values in a temp table. How do we write the code for this in SQL...
given xml should be inserted into a single table think of having following tables. (pUniqueID is required only if you are processing multiple programme...
There is a tool packaged with SQL Server 2005 called Upgrade Advisor which will tell you what all are the migration related issues in a particular db. You may...
You may download it from microsoft site. Its also comes the the SQL Server installation media, but its better to download the latest version of the tool check...
Hi Can i get a command to read fronm ldf file which transactions were done regards Madhu K Nair <madhuotp@...> wrote: You may download it from microsoft...
Hi Can i get a command to read fronm ldf file which transactions were done regards ... Download prohibited? No problem. CHAT from any browser, without...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
