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. WHERE field=(select field from tables)??????
  2. Just being curious
  3. Select Distinct Keyword Problems...
  4. Login failed for user 'null'
  5. Show All Months in First Column of Stored Procedure
  6. Web Survey database design
  7. Application Roles for Cross-Database Joins
  8. Comparing time values
  9. Stored procedure error handling
  10. SQL bug?
  11. Bi-directional Transaction Replication
  12. bump
  13. SQL Reporting Services Passing parameters
  14. Select unique
  15. Managing ntext, text with a long text data
  16. Simple 3 table query failing.
  17. need help : SQL Server and Clear Case
  18. SQL Server Installation Failure
  19. Backup question
  20. Select statement for last and secondlast value
  21. File / table description.
  22. Protecting Database From Code Stealing and Installer Advice
  23. No results found for my search!
  24. Where to find the the allowed users of SQL2000
  25. How to find Sql Server properties programatically
  26. Exchange of login for database user
  27. DB Design / Custom Attributes
  28. certification question
  29. hOW CAN i GET THE dts PACKAGES TO WORK WITH MSDE
  30. hOW CAN i GET THE dts PACKAGES TO WORK WITH MSDE
  31. hOW CAN i GET THE dts PACKAGES TO WORK WITH MSDE
  32. Strange database problem
  33. Problems with MOD-Function by accessing MS-Access Database via SQL in Delphi
  34. Droping and adding new user
  35. Way to create table of months?
  36. need help with query
  37. CrossTab
  38. wrong select or insert into ?
  39. Pull data from Two tables
  40. dbo qualified name problem w/Access 2003
  41. Just starting to learn it . . .
  42. static/dynamic/embedded SQL distinctions
  43. Select where uniqueidentifier = 0x hex?
  44. SQL Server 2005 : Is odbc bulkcopy available?
  45. 60 GB IPOD deal found
  46. ODBC SQL Server database reconnect questions
  47. test
  48. Help With Query
  49. how many char's in varchar record
  50. TSQL Help
  51. When should I to wrap DML to transaction
  52. When should I to wrap DML to transaction
  53. mssql: insert into syntax
  54. Message: Error Enumerating Data Servers - One solution
  55. How to find SQL SERVER ?
  56. Like vs =
  57. Slow DTS
  58. Replication
  59. XML and Reporting Service in 2005
  60. Need help on a select statement using MYSQL ^.^
  61. SQL Server - Access synchronization
  62. Architecture question -- grouping different kinds of stuff...
  63. ok to delete c:\SQL2KSP4 ?
  64. DTSRun Utility Won't
  65. should be easy query question
  66. Tricky questions.
  67. count only records from left table ROLLUP or CUBE
  68. count only records from left table ROLLUP or CUBE
  69. Access running on TS
  70. ROWTERMINATOR in bulk insert query.
  71. Tripling end results of a query
  72. MSSQL SELECT error
  73. SQL Server -- how do I retrieve mail?
  74. HELP! Case insensitive database on case sensitive server
  75. Columns & rowns interchage on string the data
  76. "for" loop
  77. query help
  78. One table link breaks every time
  79. DTS Import wizard does not fire triggers
  80. Can't get SProc to work
  81. SP won't run as job
  82. Freaking column names
  83. SQL Server Software on cluster: local drive other than C:?
  84. parameterised Queries
  85. Insert into #temp Exec sproc not working
  86. Microsoft SQL Server 2005 install problem.........
  87. how to check does some database exist ?
  88. What are common indexes?
  89. View from a table
  90. Updateable vuew
  91. ISQL call problem
  92. Last Entry in a Log
  93. SQL query
  94. Help getting multiple listings
  95. using own functions
  96. EXEC keyword
  97. converting string to date
  98. How do I change the Type of a Stored Procedure from User to System?
  99. How to LIMIT results in an html php/sql query?
  100. GROUP BY column-name problem (need expression)
  101. JOINS to Sub-Queries -vs- JOINS to Tables
  102. SQL Security related
  103. Calling DTS From Stored Procedure
  104. last time someone connected to a database
  105. Linked Server Trouble to Oracle
  106. Installation of SQL Server 2005 on the partition disk drive
  107. HELP PLEASE!!: How to connect to SQL Sever 2000 from Solaris?
  108. XML to Database
  109. Using one single-application connection vs. one connection for every operation to SQL-Server via ADO.NET
  110. Backup failure Error Log Messages
  111. executing querys from a batch file
  112. Copy permissions
  113. Help with trigger
  114. Development - Production Data Access
  115. DB Design Question & Performance in MSSQL
  116. MAC Address attribute
  117. Phone # question
  118. alter table #TempTable problem
  119. BCP Troubles
  120. Select with aliases, please help
  121. Select with aliases, please help
  122. Dynamic Variables?
  123. dbo.dtproperties information
  124. How to get a job current_status in Stored Procedure
  125. How can I synchronize tables?
  126. Choosing Compression Utilities for Database Backups
  127. SQL Server Instances
  128. 256 table limit for partitioned views
  129. Ansi Nulls and quoted identified
  130. How to know a Job Status from Stored Procedure
  131. How to know a Job Status from Stored Procedure
  132. How to obtain constraint (key) info
  133. How to obtain constraint info
  134. SQL select records NOT in both tables
  135. Triiger -vs- Constraint
  136. Adobe GoLive 5.0
  137. Clustered index and varchar
  138. Meta Data Catalogue
  139. For XML: create elements using cell values
  140. Functions and Execution Plan
  141. The process could not log conflict information
  142. Stored Proc Question
  143. Importing multiple files to SQL
  144. Difficult SQL-JOIN/UNION-Problem
  145. Too many sa failed logins
  146. Does MS SQLServer support auditing in the way that you can for Sybase?
  147. index bloat?
  148. Failed insert query
  149. Line 1: Incorrect syntax near '='
  150. Configuring SQL MAIL
  151. Concurrency in Transaction
  152. Help with a list variable
  153. Moving the distribution database
  154. general Q about formulae
  155. Downgrade SQL Server edition
  156. Performance-String searching
  157. change not null to null, default value to empty
  158. self join or stored procedure
  159. DateTime in UTC
  160. Query Question
  161. Help with "IN" in stored procedure.
  162. Shameless self promotion
  163. Convert Foreign Key to Foreign Key with Delete Cascade
  164. TSQL DEVELOPERS/ C TO H/ ATL
  165. Table structure of Linked server
  166. How to get table list from a db? Thanks!
  167. Difficult SQL-Problem
  168. Non-US address
  169. Which is a Good SQL Server Editor
  170. Question about Proximity (NEARness) with Full Text Indexing on SQL Server 7
  171. Insert or update into a Image column causes data to double in size
  172. Problem > 1 GB memory
  173. Migrade Oracle data to SQL Server 2000
  174. Upsizing questions
  175. backup location
  176. All Roads Lead to Rome but which One is Most Desirable?
  177. My design - where did I go wrong?
  178. MIcrosft SQLServer Best Practices document on securing SQLServer
  179. Retrieving metadata
  180. why do generated script begin with empty transactions ?
  181. IF ELSE with WHERE, AND, OR
  182. n00b question: Connecting to SQL Server at ISP?
  183. recreate system tables
  184. Msg 512 but no duplicates!?!
  185. 1
  186. 2006-07-26 00:00:00
  187. identity, plus pk?
  188. general network error
  189. Scheduling a script
  190. Aggregate column comparison in sql server sql ?
  191. Report query
  192. Yukon XQuery question
  193. Need help with SQL query. Keyword matching.
  194. Easy question on UPDATE
  195. Scheduled Job Sometimes Error Sometimes Not
  196. Hardware configuration help for MS SQL server
  197. Anything that you find in SQL object scripts, you can also find them in system tables?
  198. OSQL Unicode Insert of ^F (Hex 06) from Registry Multi-String Value is Duplicating in DB
  199. Help with SQL Query
  200. MS SQL Reporting Service in Windows 2003 Server
  201. Users advice seeked
  202. Very slow distinct select
  203. Question: Sun-developed SQL 'proxy'
  204. RowCount VS TOP
  205. Using CASE .. WHEN to have 'dynamic' sort
  206. Help on creating a user function.
  207. Upgradation Of Service Pack from 3 to 4.
  208. Use SQL-DMO, ADO or ADO.NET?
  209. How to check the last modifys in database
  210. view vs. function vs. procedure - really basic question
  211. security of mssql database?
  212. How can I shrink my TempDB Databse?
  213. Check constraint - SQL problem
  214. Performance Condition Alert Type
  215. Sql Problem
  216. Convert month name, year range to mm/dd/yy
  217. Linking SQL Server 2000 to DB2 Connect 8.x
  218. Flat file to QUASI-Relational ?
  219. Update queries using more than one table
  220. Stored Proceedures
  221. Using Month Year Table
  222. How to query by keyword for image field.
  223. Massive amoutns of Reading
  224. How to find how a record was deleted
  225. Verifying Connection to 3rd Party Application
  226. Auditing user and security related activities in SQLServer
  227. WHAT DO I USE TO MAKE A TODAY DATE QUERY
  228. WHAT DO I USE TO MAKE A TODAY DATE QUERY?
  229. ADODB connection with SQL2000SP3
  230. Use of set xact_abort on/off
  231. YellowFin
  232. mmx.exe as encountered a problem and as to close
  233. I wish to Avoid ...
  234. Using NOT EXISTS in an INSERT procedure
  235. comp.databases , comp.databases.theory , comp.databases.ms-sqlserver
  236. Why can't I load my DTS job using sp_OAMethod
  237. How to service data for multiple customers
  238. mssql lacks
  239. sp_ExecuteSQL in User Defined Function
  240. Export to Excel in MS Access
  241. Code for 1st day & the Last day of the Previous Month
  242. Make changes to a production database!
  243. reporting services excel export
  244. Query with single quotes using OPENROWSET
  245. SQLServer and network shares
  246. Query Critique
  247. Port security question
  248. SQL Login audit log
  249. Writing code to compare database schemas
  250. empty status of a variable
  251. Time Out Problem
  252. easily editting fields with more than 1024 characters
  253. Trigger For DateTime
  254. Advance Update Statement Sql Server
  255. temp table name
  256. problem about right aligned data when using bcp
  257. duplicate rows but no key on the tables
  258. OpenRowSet BUG?
  259. Query Help Please
  260. Verify phase fails on SQL Cluster on Win 2003 Server
  261. False error when trying to return data in datagrid
  262. Delete records not matching Top25 in GroupBy
  263. Delete all records in tblA not matching in tblB
  264. THE SELECT STATEMENT
  265. Using stored procedure result set in another stored procedure
  266. SQL Server 2000 ODBC related issues...
  267. sql statement
  268. Insert Into with Select
  269. Is it a good to replace SQL script files with XML files?
  270. I want to avoid using a cursor, please!
  271. backup error - error 112
  272. Synchronized Versions
  273. importing chinese text
  274. Database User Privilege Report
  275. Left Outer Join vs. pkey in (...
  276. Suspect msdb database
  277. sp_ActiveDirectory_Start problem
  278. Strange SP Problem
  279. Connecting to MSDE
  280. OPENXML question
  281. Creating a Group By without functions -- possible?
  282. msaccess to mssql server query parser/convertor
  283. Is it possible to export a View to Excel in MS SQL 2000 ?
  284. SQL Server Licensing
  285. Stored Procedure HELP!
  286. Need help with Importing XML data to a table
  287. Query Help Please - Consecutive Dates
  288. rsErrorOpeningConnection with oracle
  289. IIS 6.0: How to backup IIS 6.0 and How to restore it after it crashes?
  290. Bug in Enterprise Manager?
  291. How to Passing Multi Value Parameter in SQL Query
  292. How to convert binary trace data
  293. Selecting from different tables
  294. Error Notification from User Defined Function
  295. need help with SQL query
  296. Basic "getting started" Info on MSDE 2000?
  297. Getting 2 SUMs from the same table
  298. SQL query
  299. Integrity between table and View
  300. uppercase trigger
  301. Dates prior to 1753-01-01
  302. counting field totals as a formula
  303. T-SQL SERVER DEVELOPERS/ ATL
  304. Timestamp via Java
  305. Table Lock
  306. strange problem with dates
  307. Method of providing standby
  308. SQL Replication Question
  309. SQL Forum
  310. T-SQL how to deal with results from stored proc
  311. Copy one row from tableA to tableB
  312. Preventing Duplicate Rows on Insert
  313. Good site for data mining resources
  314. Query error during runtime
  315. Replication Monitor
  316. use of 'index' as a field name
  317. SQL's equivalent of Excels VLOOKUP formula??
  318. Moving data for reporting
  319. Complicated query - select based on value
  320. Veritas SQL agent vs. SQL .bak
  321. STOP unexpected_kernel_mode_trap after installing SP4
  322. backup from one server, restore to another
  323. Descending Sort on index
  324. Comparing two SQLServer databases
  325. Is it a SQL Server 2000 bug
  326. T-SQL problem...selecting TOP 1 of each GROUP in GROUP BY?
  327. DATABASE EXPLORER, LOADER, REPORTS
  328. How to disable a warning message ?
  329. Oracle Stored Procedures VERSUS SQL Server Stored Procedures
  330. Erwin or Foglight
  331. Removing system replication tables.
  332. Insert query takes lot of time
  333. difference between FOR INSERT and AFTER INSERT triggers
  334. Select Top Alters Order
  335. Combining Stored Procedures
  336. Why nested views are not recommended?
  337. Fulltext Search
  338. Subqurey returns more than one value error HELP....
  339. Problem with Hyphen in Full Text Catalog Search
  340. ##temp table already exists problem
  341. Reading data from Navision to SQL Server: Date issues
  342. create table from another table
  343. Perot Systems Open House -- Plano Texas
  344. Audit Tables and triggers
  345. SharePoint Services Event ID 1007
  346. Send alert from job
  347. simple select problem
  348. >> Can Google web search index the data in my database?
  349. RenderStream fun!
  350. stored procedure question
  351. Rollback issue
  352. stored procs - specifying ORDER BY as a parameter
  353. Can I use osql to known the database install on a server via 'guest' ?
  354. Diff between "LEFT OUTER JOIN" and " *= " when condition
  355. Client EM produce OS "failed login errors"
  356. User defined data type used in stored procedure parameters
  357. Service fails to start
  358. For XML clause
  359. Trying to understand triggers
  360. Explicitly fail a SQL Server Job in SQL Server 2000
  361. Updating a large table: set @@rowcount versus explicit transactions
  362. Using CASE or IF with INSERT
  363. ?HLEP..Sql Server UPDATE INNER JOIN QUERY ?????..
  364. Can SQLServer produce Excel Spreadsheet output ?
  365. Connect to SQL Server dialog
  366. DTS Job - Suspend on fail?
  367. tempdb log full error with plenty of disk space available
  368. ACT Logins
  369. Performance Issues - Access 2000 Frontend SQL Server 2000 Backend
  370. Unique number/sequence
  371. Last Date Stored Proc Updated???
  372. SQL Installation Problem
  373. Get rows with duplicate values in certain columns
  374. Script to stop a SQL service
  375. Backup on network!
  376. cascaded select
  377. Need Query to Select VarChar Rows that can convert to Integer
  378. Deletion of Duplicate Row
  379. sql trouble
  380. Why is sp_helpdb and sysdatabases different
  381. how truncate scientific notation from Real?
  382. Related tables
  383. T-SQL create self-reference in depending table
  384. Insert Records From Table1 that do no exist in Table2
  385. Can SQL tools be installed from server install?
  386. Why is it called Stored Procedure instead of Stored Sets?
  387. DBCC DBREINDEX not working
  388. MSDE and SQL2000 on Win2k3
  389. Reporting Services 2000 Projects In Vis Studio 2003
  390. Restoration From Network Drive
  391. one to one relationship
  392. Exporting data to Excel from a DTS
  393. Log file size not reduce
  394. SQL queries that have parameters passed by user
  395. Serializable transactions and insert.
  396. Use of user defined in SELECT clause
  397. stupid SQL question on Where clause
  398. Setting permissions on master.dbo.syslogins
  399. Transaction not commited rollback?
  400. MSDASQL to NOTESSQL (odbc)
  401. Global temporary table and SP
  402. Sales of SQL Enterprise processor 2000 license
  403. How to exec stored proc dynamically
  404. The network path was not found
  405. ASP.NET Application - Migrating from Access 2000 to SQL Server 7
  406. T-SQL UPDATE .. FROM .. ORDER BY problem
  407. Bizarre maintenance plan failure (db backup)
  408. Member Key found in Fact Table but not in Dimension
  409. many tempdb locks?
  410. MS SQL 7 and 2000
  411. Comparing Log Tools
  412. Crystal 9 hyperlink text
  413. Replication or bcp or DTS?
  414. Distance Between Postal Codes
  415. Stored Procedure
  416. Sp_executesql Silly Error
  417. Database restore
  418. Deletion old data in replication environment
  419. Dynamic If Update() in Trigger - Urgent!
  420. Need your expertise in SQL Server and Windows Server 2003
  421. SQL 2000 and UTF-16 encoding
  422. How do I bring in a date which is in Integar form into a databse as a date form.
  423. best way to optimize certain tables
  424. timeout issues solved by recompilation
  425. INstalling SP4 for MS SQLServer 2000
  426. Can't create table
  427. SQL 2000 Parallelism - is it worth it?
  428. Unicode chars with like query statement problem
  429. question on index used by optimiser
  430. Restore databases to different server
  431. Database design pointers (please!)
  432. SQL Agent Mail Notifications
  433. SSL only works when ms sql server has "force encryption
  434. How to Change AutoNumber Not Start From 1
  435. Question regarding stored procs
  436. Query help - giving a date range given the start date, thanks!
  437. Copy objects Wizard - deleted data????
  438. functional testing a database web app
  439. Bulk Insert
  440. Conditional -- ?
  441. Linguring SPIDS
  442. Multiple Insertions
  443. Login failed for user null occurs after a period of time
  444. ADSI LDAP Query 1000 Record limit for MSSQLServer linked server
  445. WAITFOR DELAY '000:00:05'
  446. AttribDescription as calculated field
  447. Converting binary to text
  448. Suggestions for a reporting system
  449. function call with table as parameter
  450. db_owner rights
  451. Subquery parameters
  452. One ms sql server 2000 instance blocks the other (thru a dts-job)
  453. Parsing a SQL Statement as a parameter and executing it
  454. Need help creating query
  455. BINARY_CHECKSUM algorithm
  456. Alternate to a not in query
  457. Has anyone seen a 25 TB data warehouse on SQL Server?
  458. OpenQuery and passing variables
  459. Concurrency Handling In Stored Procedures
  460. No disk activity during database restore
  461. Change ODBC pointer on workstations after database move
  462. Query table based on multiple keys
  463. Indexing etiquette
  464. Returning average of multiple rows in a table join
  465. Replication Problem!
  466. selective sql request
  467. SQL Openquery & Oracle
  468. Sql Query with one column as the name to another column
  469. selective sql request
  470. Search multiple job sites for you!
  471. Create Views via Access ADP
  472. query to trace all parents
  473. CHARINDEX
  474. Caller identity
  475. Problem with script
  476. Reporting Services Menu -Web
  477. MSQuery Question
  478. exclude query
  479. Problem In Doing Shrink Database
  480. Win 2003 x64 + SQL 2005 < Win 2003 32 + SQL 2000?
  481. Beginners Question
  482. sql server causes No buffer space available (maximum connections reached?): recv failed
  483. A Query
  484. Advance SQL question
  485. Fast copy big table content
  486. Can an update statement be used for interpolating missing data?
  487. Union Query
  488. merge history ip address
  489. retrieving agent id?
  490. Sql Server Password Expiration?
  491. Sorting - character after 'Z'?
  492. QUESTION: Status column of FK Constraints in sysobjects - ????
  493. set of dates
  494. Problems with Windows Authentication
  495. using a stored procedure as a sub query
  496. bulk copy error: Received invalid row length x from bcp client. Minimum row size is y
  497. SQL server process architecture
  498. Delete-operation performance problem
  499. Programming Field Lengths
  500. Change SQL Server Serial Number
  501. request issue
  502. How to Disable ALL Constraint In ALL Tables
  503. Have a better UPDATE statement than what I wrote?
  504. Tedious but not difficult!
  505. Please help with this query
  506. Top 1 Row for each ..,
  507. Top N rows, discard duplicate
  508. Wide Primary Keys
  509. Encrypt payroll fields
  510. MSSQL linked server to Oracle RDB
  511. Join Small Table to Big Table or Vice Versa, does it matter?
  512. AUTHORIZATION with WINDOWS AUTHENTICATION -- HELP!!
  513. formatting question with osql batch file
  514. Accessing publication properties from Visual Basic (VB6)
  515. Appending data to a table but not duplicates
  516. Outer Join not working when using SQL-92
  517. moving data files to a new disk, same server
  518. Care and Feeding of Databases
  519. sorting based on various data types
  520. ordering problem
  521. deadlocks involving parallelism
  522. Problem converting rows to a string
  523. Temp Table in a Stored Procedure
  524. Excel - Read-only
  525. Please help with a query
  526. SQL Server 2000 - restoring (point in time)
  527. To Use Triggers or Not?
  528. Restoring a DB
  529. Raising Error from Trigger to Stored Proc
  530. SQL Server performance problem!
  531. Locking on Tempdb...
  532. Searching
  533. Own Query language for non-technical Users, any frameworks known?
  534. Normalization Question Regarding Column Combinations
  535. VB6/SQL Server application runs locally, but not from server
  536. Problem in Update Trigger in SQL Server 7.0 - Need some help!
  537. Running VB Function in SQL?
  538. Multiple insert
  539. Transferring Data from MSDE Database to SQL 2000 Database
  540. What happens if a table has no Primary Key?
  541. SQL Server Process and Memory Usage
  542. BACKUP ERRORS MISSING IN THE EVENT LOG
  543. DTS Import Wizard Causes Crash
  544. Restoration of Transactional log Backup
  545. SQL Server Agent + SQL Mail
  546. Restricting returned rows
  547. multi keyword search SP
  548. cursor application?
  549. merge database content
  550. SQL Query: Merging Tables