View Full Version : sql server 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 35 36 37

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