Hi I am trying to BCP some data in the txt file But when i run the query below bcp "SELECT au_fname, au_lname FROM pubs..authors ORDER BY au_lname" queryout...
We attempted to deliver this message to you with HTML formatting. However, your e-mail program does not support HTML-enhanced messages. Please go to your...
MumbaiUserGroup
mumbaiusergroup@...
Jun 2, 2005 7:04 pm
1042
Come join the bandwagon to unleash the technology inside out.... Be a part of a live discussion from the convenience of your office/home and experience...
Abhishek Kant
abhishek@...
Jun 2, 2005 7:04 pm
1043
It is working fine at my desktop. Not able to repro the error. --Jagan...
Hi All, One of my friends having folowing problem: Server A: OS: Win2k Advanced, SQL:2k (Ent) uses disk station. And right now running out of space. They...
Hi Experts, Does anyone know what privilege I need to grant to allow a user to view error logs? I think the procedure is sp_readerrorlog, and I can see the ...
Hi Friends, I have a surprise experience today would like to share with everyone of you for further help. I have an application role called "MYWSAppRole". I ...
Thanks jack issue resolved. Use master go exec sp_addlogin 'readlog', 'readonly', 'master' go use master go exec sp_adduser 'readlog' go use master grant...
hi u can try this by deleteing the particular "Jacks" from the Database where we have user details. ie sysusers or syslogin tables and again create the user...
Sorry for confusion, It is not possible to add users to approle Which is a special kind. I was even not able t add users to approle using EM. Please ignore...
Hi Jacks, Application role has to be treated as different than 'SQL standard role'. From BOL: Application roles do not have members; therefore, the user does...
Also this query displays owners for all tables. select so.name [Object Name], su.name [Object Owner] from sysobjects so (nolock) inner join sysusers su...
Hi all, I am preparing for the 70-229 Exam. Can someone provide me with guidelines as to how to approach the exam. If anyone has any kind of questionnaire...
From: http://abhishekkant.blogspot.com/2005/06/get-free-training-on-vs-2005-an d-sql.html Get FREE training on VS 2005 and SQL 2005 you have heard about...
Abhishek Kant
abhishek@...
Jun 8, 2005 4:43 am
1057
Hi Navaneeth, Thanks for the reply. Actually I have all the required books from Microsoft Press and others and have almost completed those books. Still I am...
Last few days have been excited with Labs at virtual servers .. Check it out http://geekswithblogs.net/veerji/archive/2005/06/08/42609.aspx...
Veer Ji Wangoo (HCL)
v-veerw@...
Jun 8, 2005 10:36 pm
1059
Hi, I wanted to know how to export the data from a table in SQL to a tab delimited file. The requirement is as below: A batch job would call the dts package ...
hi Guys, There is a huge requirement for ASP and Sql Server Professionals in our organization (SumTotal Systems) in customer servies Team. It is only through...
You forgot mention the server name and database name himanshu sinha <kr_himanshu@...> wrote: Hi I am trying to BCP some data in the txt file But when i...
hi i tried to Restore the backup of Sql server database from 7.0 version to 2000 version.i got an error database not published and i like to know why the...
Hi all, My company requires a very strong SQL Server guy(minimum 5 years of experience) who would be a database architect and would be sent to onsite for some...
Create a blank Database and change his compatibility to 7.0 sp_dbcmptlevel <Databasename> ,70 Then restore the database and then change it to 80 as 2000...
hi i tried to Restore the backup of Sql server database from 7.0 version to 2000 version.i got an error database not published and i like to know why the...
Hi group - For our application we are using the ASP State database for maintaining the session . The SQL Server is consuming lot of memory . Is there any way...
Dear Satya, Flushing out memory as a first resort isnt the right approach.First we must know what is that which causing SQL memory demand. I am convinced that...
Hi there: Could somebody pls help me to answer this question: Find out how many customers have a total credit limit (the sum of Credit Limit on all accounts)...
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.
