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