Search results for query: *

Here's the basic format for a connection string using .Net: "Data Source=skylab1.te.hik.se,25000Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd;" You may wnat to use the acutal IP instead of the name, according to my ping your ip is 194.47.172.25. I'm not...

Thanks for response, I've played with the FOR XML before and that is what got me thinking in the first place about this ;>. I want to be able to take what the FOR XML gives me in QA and have it save to an external XML file. Ideally this would be executed by a trigger on a table or possibly using...

Does anyone know how to use SQL server to generate XML files? I'm familiar with the xml functionality in SQL server such as OPENXML, XML through http, etc but I haven't found a way to simply generate an XML document. I'd like to be able to import XML documents in as well but I'll save that for...

Q1-Change the startup property of the MSQL service in computer management to automatic Q2-Use sp_attach_db to attach a new database Q3-Yes,I believe this is only required on clients that will be running code that uses these components. It will get installed automatically with MSDE though as...

Have you tried the master.dbo.syslogins table? It has a column for each SQL Server fixed role. If the value in the column is 1 then the login is a member of the corresponding role.

One of the easiest way to move a large database is to detach (or take offline) the database and actually transfer the two phisical files that make up any SQL Server DB(.mdf. & .ldf). These are in the SQL server install directory in a folder called data. the other way is to do a backup and then...

Just a guess but maybe look into using the SendKeys function.This sends a strem of keystrokes, not sure how it works in the context of a IE window. Good Luck

Okay, thats a little different. Are you trying to remap a keyboard input into an existing application or something you've developed?

You may want to try using a DTS package instead, I believe you have more control over the format. Also, it's easier to perform multiple times once it's setup.

I've never seen anything like that before...Is there anything special about this data? Is it really large text or some strange characters, etc?

In query analyzer you can export the results to a text file by going to the menubar and selecting Query-->Results to File If you wan to set up the properties for the output file goto Tools-->Options-->results tab

You could use client side vbscript or jscript to achieve this. You would capture the keydown event and evaluate the keycode to determine which key was pressed and execute the desired code. This could not be accomplished with server side vbscript.

Legacy370, I can't use that level of transaction isolation b/c I don't want to see uncommitted rows in case they're rolled back, I really just want to see commited records and read past rather than wait for the lock to release for any rows that are being updated or not commited for some other...

Does anyone know of a way to read past locked rows in table? I come from a MS SQL Server background and in that environment you could add a lock hint after the select to ignore locked rows, such as: SELECT * FROM TABLE WITH(READPAST) Just wondering if anyone knows of an equivalant...

If you are familiar VB you should look into the SAP DCOM connector and BAPI's. There are some good books to help you learn, just search amazon for "SAP DCOM"

I'm having problems creating a .dll using the DCOM Connector Object Builder. The problem occurs when I try to buiuld the compnent. It generates all the files required by the .dll howver it fails with the error "LoadLibrary(""Accounting"")failed" where...

Thanks for reading my thread, I'm looking for a checklist of configuration, optimization, maintenance, security tasks for multisite (20+ remote sites) SQL Server 2000 based application rollout. My goal is expose and work out the configuration and setup details before deploying the monster to all...

WOW! Do I know you? I am also a consultant performing data migration. Everything you mention is like deja vu. One thing that's tough to get used to for me is the feeling I get when I go into a client site and I know that I'm eliminating peoples jobs. Typically the IT staf that is currently...

Check out the book Professional VB SAP R/3 Programming. This book will help you extract data related to most any SAP objects as well as creating and modifying data through your VB and VBA applications. The mechanism that allows this is included on the SAP frontend installation CD. The component...