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