View Full Version : answers

Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 [15] 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
  1. complex merging query in sql server 2000
  2. Retriving multiline Value from a database
  3. Sum Comma Seperated string
  4. Peachtree to SQL Server
  5. dynamic cursor - sorting in declaration
  6. Stored procedure works, Agent job aborts
  7. need to open text file for datapump from activex script
  8. need to open text file for datapump from activex script
  9. Updating a sequence number (not identity insert)
  10. Output of international characters to text file
  11. SQL Query help
  12. running backups from a batch (.bat) file
  13. how to move data files from one location to another with MSSQL.
  14. SQL Build Scripts .bat files
  15. Changing compatibility level from 65 to 80 - Whats up?
  16. Artificial Mind - Part One - Basic Architecture and Cognitive Structure is now available
  17. How to retrieve query results with now field names, dotted line or footer
  18. Copying a DTS Package and Jobs
  19. Selecting a different field from a group.
  20. Passing parameters to stored proc from Crystal reports
  21. How to delete repeated entries from table using T-SQL statement
  22. How to find All Permissions in the Current Database for a particular User
  23. After a corrupted publisher
  24. sql statement
  25. data types
  26. Calrification on number of columns fetched to server memory
  27. DB2 ver.4
  28. execute command - urgent!!
  29. How to transfer data from Oracle Table to SQL Table
  30. Sql Backup
  31. Date overlapping
  32. Problem Copying Table
  33. Spectra force @@@@@ HOT LIST@@@@@
  34. MSSQL Script execute in .bat
  35. How to copy data from MS Excel to MS SQL Server using DTS
  36. MSDTC error in Windows xp environment.
  37. List users and permissions in a SQLSERVER2000
  38. mmc.exe - .dll files are corrupted
  39. CONTAINS in SQL Server
  40. Insert statement conflicted with foreight key contrait.
  41. Connection string problem.
  42. Urgent requirements ----- Oracle Apps Finance Functional
  43. Migrate from MS Access to SQL
  44. Problem with stored proc.
  45. Creating a text file
  46. Could not find installable ISAM
  47. Blank Password Policy problem
  48. [help] ALTER TABLE: error message 4929
  49. Need to utilize exec('use '+@nvcDatabaseName+';
  50. INSER at runtime?
  51. Select Statement.
  52. transaction log file is full
  53. Best way to force a varchar column to have no whitespace
  54. MS SQL server uses 3.7 gb memory and %100 of my huge server
  55. MS SQL 2000 import from MS SQL 2000
  56. Installing SQLServer2005 but Preserve Current SQLServer2000
  57. White space in a field
  58. drop down list
  59. Not In / Not Exists
  60. A script to delete views
  61. keep running process even killed
  62. Replace Multiple LIKEs
  63. Building data base on local machine.
  64. query to obtain files whose last status=2
  65. how to query for text containing parens?
  66. Snap-in creation failed
  67. Urgent requirements -----PL/SQL Developer & C#.Net Developer
  68. please if you no how to fix this help me please
  69. build a query which access to multiple databases
  70. Exporting Data from tables to text file all at once
  71. ALL and empty set
  72. Need help with SELECT Query. dont know what topic
  73. connecting oracle and sql
  74. Unexpected Casting With Sum & Coalesce
  75. call stored proc on sql 2005 from 2000
  76. how to change default data directory for SQL 2005
  77. SQL SERVER 2005 maintenance plan
  78. Recover Mode set to Simple for Unknown Reason (not MSDB)
  79. Update Query containg static data and data from another table.
  80. Invalid column name 'ProjectQuestionContentDateTime'
  81. Insert Japanese from ASP page into MSSQL Server 2000 database
  82. Searching problem
  83. Sql Server 2005 Maitenance Plan
  84. get todays date and a certain time
  85. Q on joining tables with nullable fields
  86. Passing multiple values into a stored procedure...
  87. Sql Server 7 To Sql 2000 Upgrade
  88. Non English Characters
  89. Use of LIKE in Cursor degrades the performance?
  90. question on reindex
  91. SQL 2005 hogging resources
  92. datetime columns
  93. Install Problem
  94. Update Query Help!!
  95. How accurate is GetDate() ?
  96. software RAID-100
  97. CVS with SQl
  98. Text Data Type Problem
  99. concatenation
  100. getting problem while inserting using linked server
  101. MSSQL arguments in PHP
  102. Alter Table name
  103. concatenation with space
  104. one of the tab in SSISS is not working correctly.
  105. Sql server 2000 performance tunning
  106. Invisible stored procedure?
  107. store db objects in *.ndf vs. *.mdf??
  108. set default value for a char column??
  109. SQL Server 2000 Transaction Log Backup Question
  110. Date comparison problem
  111. Date comparison problem
  112. SQL Server Slow
  113. Cursor help please
  114. query
  115. SQL Server Agent
  116. insert statement blocked
  117. DTS from excel file (excel filename is different everyday)
  118. stored procedure compile
  119. what should i do when i want to save a select resultset,but not in a new table,in memory is the best?
  120. reset sa password msde (sql server 7)
  121. Problem displaying extended ascii characters from sql server in html
  122. Better way to use BETWEEN Begin and End Dates
  123. SQL Transaction Log File
  124. ODBC: Call Failed
  125. how to get this resultset...
  126. DTS Works, job fails!(data source Foxpro and destination SQL Server 2000
  127. Master File not Accessible for Copying
  128. Regarding Replication Concept
  129. MD5 encryption
  130. Help with Crystal Reports subselect
  131. Insert trigger to populate other columns in same row
  132. xp_cmdshell problem
  133. SQL Address
  134. SQL help Needed
  135. Interesting Data Mining Forum
  136. SQL and MSMQ
  137. Keyword Search Help
  138. Point in Time Backup (impossible for some points?)
  139. Where to Begin
  140. Using USER value in SQL code
  141. QUESTION: Performance issue on *one* database on a server
  142. Breaking down Total Hours worked into Day and Evening hours
  143. How to Delete Login (SQL-DMO)? - SQL 2005
  144. Upate table using ADOX in VBScript
  145. Question on moving logs
  146. Dyamic view/function based on table data (?)
  147. FK - urgent
  148. UNION / INTERSECT / EXCEPT in SQL Server 2000
  149. How To Calculate Database Size In Sql 2000
  150. data is not exporting to excel in sql server 2005 client edition
  151. Obtain the query plan of a running process
  152. Create Procedure Permission ONLY
  153. Migrating data from SQL Server 6.5 to SQL Server 2005
  154. Trigger to reset Table Rows
  155. composite primary key
  156. about efficiency(rephrased)
  157. Converting from String to Numeric Problem
  158. cursor to compare/report on the same fields in 2 tables
  159. lookup data in form
  160. Export/Import data
  161. how many times Identity value has been reset?
  162. What queries were run?
  163. Question on System and Data Restore
  164. Foreign Key Relation with composite primary key table
  165. Sql-dmo
  166. Trace file in MySQL
  167. about Efficiency
  168. help with Select statement
  169. Character set support
  170. DELETE failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'
  171. dba activities
  172. SQL server connection
  173. Foreign Key
  174. Cannot Open .bak File from ms sql database. either 2000 or 2007
  175. DTS Packages from 1 SQL Server to another
  176. Help needed with DATETIME Arithmetic
  177. SQL Server "Light"
  178. Replicate SQL Server to MS Access MDB
  179. Microsoft OLE DB Provider for ODBC Drivers error '80004005'
  180. Updating columns in sql server from text files
  181. Show data in ASP.NET datagrid control in cyrillic
  182. Download Ebooks
  183. Why cannot set Unicode string
  184. Why cannot set Unicode string?
  185. Go to the last record
  186. rebuild
  187. Send Sms From SQLServer2005 to MobilePhone
  188. optimization
  189. Looping a stored procedure in a dts package
  190. How To Select a Certain Limited Number of Rows Per ID
  191. Appending data to an existing record
  192. Copying table data from a different database
  193. Update using Substring
  194. Help - Finding the newest date without using max()
  195. import txt-file via batchscript to SQL 2005
  196. Update sub query
  197. Update sub query
  198. time stamp data type
  199. Indexes vs Clustered Indexes
  200. SQL 7 to SQL2005 Migration
  201. Download the JAVA , .NET and SQL Server interview PDF
  202. Trigger - On insert ~ if [column] value = XX, change it to YY, then insert
  203. howto use the query results as view column?
  204. formatting for a birth date field??
  205. Problem running stored procedure inside another store procedure
  206. Yellowfin Reporting Release 3 OLAP Connectivity
  207. The scripts in the store procedure run slowly, but quickly exec in the Query Analyzer
  208. Using a trigger to generate an ID value
  209. Select and Insert Question
  210. looking to tune query...
  211. Removing HASH Match / Inner Join
  212. Deletion on multiple tables
  213. Dynamic Select in MSSQL
  214. last record in table
  215. Row versioning in SQL 2000?
  216. Line Break in T-SQL
  217. Actual and Estimated Rows
  218. how to run the servlet
  219. Can I avoid temp tables, etc.
  220. Synchronizing Access and SQL Server
  221. sql server i/o bottle neck ?
  222. For SQL Buffs
  223. sql 2005 client tools
  224. Excel Inserts Null Values in DTS package
  225. How do I send query output to a file?
  226. DTS Automation - Huge Problem
  227. SQLRef - Website Created by Programmer to Programmers
  228. database migration using DTS help
  229. The user does not have permission to perform this action.
  230. urgent!!! convert to datetime format from varchar...someone please help...
  231. PKZip issue
  232. Trouble with converting time/date
  233. sp_executesql in triggers
  234. Query is slow sometimes
  235. Error 18024
  236. stored proc bug with datetime variable
  237. export to sql 2005
  238. SQL Between Dates
  239. Recurring Scheduled Job
  240. database converters
  241. Union or Join or or
  242. Flattening Parent Child, an issue, please help
  243. How to make this an efficient query?
  244. Select * and display days overdue
  245. SQL troubles with VPN connection
  246. est
  247. test
  248. Best practice for storing long text fields
  249. Managing MS SQL on Linux
  250. Error in my SQL Syntac
  251. Find out the percentage complete of Stored Procedure
  252. Tree table
  253. sql profiler
  254. Memory setting right ?
  255. Database Maintenance Plan
  256. How to get a SP return value on another SP?
  257. convert column into datetime format
  258. Moving objects from 1 SQL Server to another
  259. Permissions for ODBC to SQL
  260. Want to get monthname from a date
  261. DTS Automation - a tuffy
  262. [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name on Linked Server
  263. return values and recordset in one stored procedure
  264. Top and Views
  265. Passing SELECTed rows to a calling SP
  266. cross server update problem
  267. HOW TO Transfer my sql server 2000 data base to server on the internet
  268. Computed Column Specification
  269. One more connection problem-Security Issue
  270. I have no blog
  271. SQL Server E-Learning
  272. ADO.NET problem?
  273. need query...its urgent
  274. query in msaccess
  275. Order of Merge Replication
  276. See Sql server but not databases
  277. .NET assembly for BULK INSERT
  278. Problems with DTS
  279. Please evaluate this approach to shrinking log files
  280. why the difference in DTS?
  281. Osql join command
  282. how to use SP's output in the SELECT Statement
  283. trigger - v.urgent
  284. how to get all records of a person in perticular month
  285. SQL Server 2K Database Name Problem
  286. How to display the managers and the employees working under that Manager
  287. Reg: database connectivity between SQL and ORACLE
  288. Finding a line number
  289. How to converting float to date
  290. Is it possible to move a database from 2005 to 2000?
  291. Need advice on reading material
  292. SQL Server 2005 connection unusually slow even errors.
  293. Unable to Insert in Temp table through RPC
  294. transaction inside sp_executesql
  295. How to use result set returned by Stored Procedures?
  296. How to use result set returned by Stored Procedures?
  297. Replication between SQL7 and SQL2000?
  298. Finding name of DTS package thats called from scheduled job
  299. trigger
  300. About Creating Relationship
  301. Sql Server 2005 Image Storage and Retreival
  302. Creating a dynamic Global Temp Table within a stored procedure
  303. Trigger problem
  304. What is the meaning of "LTRIM(N' ')" ?
  305. what is the system requirement installing ms sql server 2003 client version?
  306. Which to install first, VSTO or SS 2005 Developer??
  307. move/copy database objects from SQL Server Express to SQL Server Standard??
  308. Getting non matching records from 2 tables?
  309. Upgrade SQL Server 2000 Failover Cluster from SP3 to SP4
  310. Are these DB's required??
  311. Running MS Access db as a Linked Server on SQL Server
  312. specjalista od mssql2000 na jednorazowe zlecenie
  313. Download the JAVA , .NET and SQL Server interview question with answers
  314. An interesting Lastname, Firstname, Middlename challenge
  315. Convert Rows into Columns
  316. Server configuration for MSSQL 2000 and MSSQL 2005
  317. BULK INSERT Help needed bad!
  318. MSDE
  319. Facing some problem in Instead of Trigger for MultiRow Insert
  320. Query performence about nText
  321. collation
  322. difference between BCP and DTS
  323. How can i see all trigers that i created
  324. ldf & mdf
  325. SQL Server 2005 - BULK INSERT
  326. installation of ms sql server 2000 developer edition on windows xp pro
  327. login failed for user
  328. procdures and functions
  329. foreign key
  330. rowid is there?
  331. Sql Server connection problem
  332. Can't Keep Primary Key Columns when moving db to SQL 2005 from 2000
  333. Storage usage for Enterprise Applications
  334. Comparing two tables and spitting out an XLS
  335. besoin d'un petit coup de pouce
  336. Drop Replication components
  337. Stored Procedure To Update Columns
  338. Restore Messed Up Table Names
  339. BULK INSERT into table with identity column?
  340. Does SQLMail require a mail account on the Exchange Server?
  341. DTS that does HouseHolding with Millions of records
  342. Basic TSQL - DISTINCT in PK
  343. need help on normalizing the tables
  344. Column order/presentation in virtual table (result set from viewor UDF)
  345. Text Column question
  346. Insert Uniqueidentifier after the fact
  347. Need advice, new to VB 6.0 and SQL server 7
  348. need a query please help
  349. Replication Query
  350. estimation the buffer cache hit ratio
  351. CREATE FUNCTION with COBOL doesn't work!!
  352. identity insert
  353. Create CUBE Roles automatically: Please help
  354. Import data from excel sheet to ms sql server table
  355. primary key
  356. Cursor Problems
  357. Foreign Key Constraints problems
  358. Databases updating simultaneously
  359. Self-Reference cascading deletes
  360. SuperSocket info: (SpnRegister) : Error 1355.
  361. Return a string representing the day of the week
  362. Need most recent record from views.
  363. Stored Procedure to return table?
  364. Concatenation and Formatting output in T-SQL
  365. About LogShipping-Urgent
  366. Inserting Data
  367. Calculating Positions Query Required...........
  368. Looking for database backup command
  369. Microsoft SQL Server 2005 - DB
  370. Deleting record in table B on deleting record in table A using Trigger
  371. Changing schedules for a Job outside SQL Server
  372. sql server case sensitive?????????
  373. Mssql
  374. Easy cross referencing question
  375. Error 8115, Level 16, State 2
  376. How do you create ##Temp tables if they don't exist, use them if they do?
  377. Converting strings to dates
  378. [DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error
  379. books online download link please
  380. Distinct
  381. How to install SQL Server 2000
  382. SQL server Back up
  383. Update a column
  384. cross server insert @@error
  385. Import ASCII Data
  386. DTS From SQL Server 2000 to Btrieve
  387. Tough Correlated Subquery issue
  388. How to allow FULLTEXT SEARCH INDEXING to non-admin user?
  389. Is there a way to transfer ntext data from one table to another? MSSQL2000
  390. functions and procedures
  391. is rollback possible here?
  392. Using DAO to access binary data in Sql Server 2005?
  393. OLE error code:80040E14
  394. MSDTC and Delete transactions
  395. MSSQL2K5 Install Path
  396. dbcc checkdb
  397. Installation of local database
  398. grant access to extended properties
  399. delete sql server registration in tsql
  400. MSX/TSX
  401. problem on login: user is inactive
  402. Database indipendent queries
  403. [Sql2000] how to limit table size
  404. How to change db owner for SQL Server 2000 database
  405. how to change password?
  406. Checking if DB Connection is active or not
  407. Row mapping from one table to another
  408. Counting the occurence of a string ...
  409. OPENOFFICE BASE
  410. Moving from mssql to postgres, advice needed
  411. joins
  412. SSIS Standard Edition and Script Task
  413. Totals on change
  414. SQL Http Interface
  415. Finding a creator of object
  416. sql server is not starting
  417. can we provide security for .war file in java
  418. deleting duplicate records
  419. Import Excel into Ms SQL 2005 Automatically
  420. When DTS hits a bad date
  421. Normalizing a Crosstab
  422. Variable Math in Stored Procedure
  423. Primary key generating
  424. Transaction log keeps growing
  425. Replication performance - how to measure it ?
  426. Candidate key
  427. Problem with export of a table to a text file
  428. Can any one explain this query behavior
  429. Temp Table Column Type?
  430. Table Query Timeout Problem very specific
  431. Merging two tables with selection
  432. Help me with this query please.
  433. Help me with this query please.
  434. Case help and Identity help
  435. Efficient Store Proc for Paging Very large DataSet using Cursor Approach
  436. minimun installation
  437. wow
  438. Performance: Server Agent v's Query Analyser
  439. SQL Running process
  440. replication
  441. Whitepaper: "Yellowfin Reporting" enables Embedded Business Intelligence
  442. Max Row Date
  443. How do I get a count of each set of results?
  444. Changing DSN to DSN-Less
  445. Logging information about items of the Data Flow Task?
  446. adding unique keys
  447. SSIS Packages Dashboard
  448. Incorrect syntax near the keyword 'THEN'
  449. SQL 2000 dies on JOIN query
  450. 6.5 master database syslogs full
  451. data transfer
  452. columns as rows and rows as columns
  453. Viewing transactions in SQL server 2005 express
  454. what is informatio_schema.<something>
  455. sum problem please help
  456. USING 'CASE' TO GROUP DATA
  457. SQL query dilemma
  458. mp3 songs in SQLSERVER
  459. Trigger on a table in TempDB
  460. User authentication
  461. SQL DTS to DB2
  462. Collation problem - urgent help
  463. okay, I'm frustrated....how do I
  464. Problem with SELECT
  465. SQL Server 2005 - FILE manipulation hanging....
  466. Difference between 2 tables
  467. flat file connection string
  468. nee stored procedure please help
  469. Using SQL Server 7.0, Backup maintenance plan not working
  470. Marketplace Announcment: Yellowfin Reporting Version 3 rollout
  471. Summarize Unique changes of registration
  472. sqlserver 2005: indexes on raid-0?
  473. Creating rows based on date range from another table
  474. SQL Insert Help
  475. transaction log
  476. Move Databases on SQL 2000 Machines
  477. Changing stored procedure Freezes Crystal
  478. Recommendation for tools converting access databases to SQL
  479. Log Shipping Snyc Problem
  480. Using aba_lockinfo in a loop
  481. Help with query - anyone??
  482. Absolute Newbie Question
  483. Alter a SQL table
  484. do SS transaction logs have to be backed up for recovery to POF?
  485. Access to SQL Server Query Translation
  486. Best way to move datafile from C drive to D
  487. Hourly Average
  488. OLAP Specialist vs OLTP one?
  489. SQL Server 2005 Opening Script File Problem
  490. how to add primary key in existing table
  491. Does truncate and API Load invalidate statistics
  492. Slow Insert in SQL Server
  493. SQL select statement needed
  494. I can't create a temp table
  495. SQL access problem (SP2 pre-installed)
  496. Array / Table As return Type
  497. union all and order by problem
  498. Weird situation - Stored procedure executed twice
  499. installation problem for SQL 2000 Development Edition
  500. Trying to do REALLY simple procedure and loop in SQL Server
  501. SIMPLE command to convert string to number? Not CAST or CONVERT.
  502. SQL 2000 only using 8GB of 16 GB available
  503. Only update changed columns
  504. suggestions for books
  505. Views, UDFs
  506. Stored proc duplicating data
  507. Views
  508. After SP4, proc w. Cursor doesn't release keylocks
  509. Using FormsOf(INFLECTIONAL, )
  510. Multiple Search Criteria using FREETEXTTABLE function
  511. clustered vs. non clustered
  512. copy database via tapefile no SQL 2005
  513. need help with LEFT JOIN statemen
  514. Almost there with bulk insert
  515. Create View in SQL Server with data types
  516. SQL Server trigger that fires only on update of certain field?
  517. transaction logs full
  518. MS SQLServer or Pervasive SQL 2000i
  519. Validating State abbreviations using a Check Constraint
  520. Selecting on multiple tables
  521. SQL Server 2000 / [USA edition] = UK ???
  522. dependent assembly microsoft.vc80.mfcloc could not be found
  523. dependent assembly microsoft.vc80.mfcloc could not be found
  524. Accessing form controls values through ms sql fuction
  525. SQL 2005-Config Manager contains no data
  526. SQL Server 200 Developer vs Enterprise versions
  527. Weird DTS Problem
  528. Trigger problem in SQL
  529. Get the latest result (new in sql)
  530. Trouble with Impersonate User, ODBO and Analysis Services
  531. Hey I've got a homework problem I'm working on and am stumped.
  532. ALTER TABLE from sqlcmd script
  533. How to switch off automatic blanking of table views in enterprise manager ?
  534. 'MSDASQL' headache
  535. Flattening Parent Child Hierarchy: Urgent please help
  536. Error in Creating table in Sql server 2000
  537. New to stored procedure
  538. format files for use with bulk insert
  539. How to creat a sp for insert datas...
  540. Get files in different folder using sql
  541. Skip rows where the first column with letter 'S' - BCP
  542. Get column names with the corresponding table name from a SELECT with JOINs
  543. SQL Server Management Studio can't 'see' the 2005 engine?? But can see 2000 ?!?
  544. Tying together tables
  545. Database design question
  546. Change Logical Name in Script
  547. TRAN_ABORT gone?
  548. Global ODBC Settings
  549. Regional Setting in MS SQL
  550. SQL Challenge Urgent, Please help