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