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. can I return output from stored procedure into an HTA to display in browser?
  2. BitArray to binary
  3. Database change tracking software
  4. Updating tables via agent ?
  5. Erro trapping question
  6. Enterprise Manager Job Scheduler Vrs Query Analyzer???
  7. Problem with date
  8. Where to put ISNULL
  9. pocket pc mssql remote database admin
  10. Select in a transaction hangs when selecting from remote table
  11. AD
  12. Sparse Hierarchy T-SQL Help...PLEASE?
  13. No triggers, constraints
  14. No triggers, constraints
  15. EM - Open table - Return Top... -1000
  16. How to Identify Permissions for SQL Server Tables & Stored Proc. via VB Code
  17. Command works in DOS but not in xp_cmdshell
  18. Connecting to SQLServer 2000 using DNS alias
  19. export from mssql database
  20. Reordering entries in form
  21. Is this possible?
  22. Help! Dates and SQL
  23. Tables and Stored Procedures
  24. How Is The SQL2000 Desktop Licensed?
  25. Help needed with Backup and Restore
  26. Access a table
  27. Lock/block retained after commit
  28. Owner of the table
  29. Select returns one row from two
  30. Problem shrinking a database
  31. Table Name in Variable - Create Statement
  32. Is there an easy way to monitor (audit) who logs onto a database ??
  33. Is Yukon Beta2 download scalable up to 8 CPUs
  34. SQL Server 2000: How to handle licenses?
  35. MS GRAPH, PASSING PARAMETERS, ACCESS PROJECT
  36. Access crashes when updating a stored procedure
  37. SQL Server 2000: not enough storage is available to complete this operation
  38. Next Run Date column not sorting
  39. Application Performance advice please?
  40. Logging Errors
  41. how can i manage database on lan base[network base]software
  42. Recover Master database fron only MDF file
  43. Use a downloaded database
  44. Primary Key: I am trying to understand--please help if you can.
  45. SQL Server takes too long to run a query
  46. [MSSQL + VS.NET] Connection - sleeping
  47. Sql Server to MSDE - good choice?
  48. how do i use select statement in update query
  49. Trigger code
  50. ASP / SQLServer connection
  51. how to use select statement in insert query
  52. String searching
  53. how do i connect from one sqlserver7 to other sqlserver7 through internet
  54. Optimizing Database
  55. How to get back the value from exec() ?
  56. Change owner
  57. SQL Server Chat next Tuesday: SQL Server 2005 Beta 2 CLR Q & A
  58. Nulls being allowed when they shouldnt be?
  59. bcp API
  60. Variable in Variable
  61. Backup to remote pc
  62. Active Script OK But Scheduled Job Fails
  63. Reporting Services: Role Assignment without using Report Manager
  64. Vchar vs Char
  65. dynamic killer
  66. Removing non-printing characters ...
  67. Changing Column Name on a table
  68. Regex parser Text field
  69. Current user
  70. Desperate! - Need simple MSSQL server monitoring scripts, ideas, etc that can be performed by operator types (non-programmers)
  71. Relationships getting deleted (MS SQL)
  72. creating trigger to auto set create/modify dates
  73. Error when writing to SQL server through asp page using windows authentication
  74. Transaction through stored Procedure
  75. SQLServer 2005 Beta
  76. limit the access
  77. Indexed Views Vs temp tables
  78. how do you know what transation ID to play forward after restore?
  79. Search Text in Database
  80. audit select on a table?
  81. Log file of test database bloating
  82. Compare two column values with leading zeros
  83. Dynamic SQL and function
  84. Lookup value query joining two tables
  85. odbc sql server driver timeout expired
  86. auditing logins in Analysis server
  87. problems registering new database with EM.
  88. MS SQL Server client under linux/unix.
  89. Adding a day to a date.
  90. Basic SQL Server Question
  91. reporting on a DTS performance reporting
  92. Hiding Data
  93. View Users
  94. Restore DB procedure - date parameter
  95. password hash
  96. Transposing
  97. how to monitor for full table scans?
  98. DBA Responsibility
  99. DECODE in SQL Server?"
  100. Lookup value query joining two tables
  101. urgent - data type problem
  102. Populating an Access combo box with large amount of data causes table lock in SQL Server
  103. Periodic maintenance like sp_delete_backuphistory?
  104. SQL Server 2000 on AMD
  105. DTCXact transaction in DBCC openTran
  106. selecting the latest date from different columns
  107. Help Trigger
  108. URGENT database security question
  109. Data model for a web messaging application.
  110. Change local variable inside query
  111. transform recordset
  112. Update sql syntex question
  113. Text column slows down select
  114. Average Computation Question
  115. Mapping image pointers to page numbers
  116. See the good, the bad, and the ugly of your SQL Server data with OneClickRevelation(tm)
  117. Update Statistics failed, incorrect set options
  118. Temp DB growing to max available disk space
  119. Manual Log shipping
  120. SQL SERVER SMP configuration
  121. invalid object like view, function etc.
  122. invalid object like view, function etc.
  123. Creating view (transpose records to columns)
  124. Data Replication performance.
  125. saving changes made to database
  126. Transact SQL probklems with variable scope
  127. Book recommendation
  128. tran log reader/viewer
  129. Restoring the master to different drive letters
  130. sorting string
  131. DTS -- SQL Server Data to AS400
  132. Help - Server stops responding to connections, stops accepting connections
  133. run 3 dynamic selects from stored proc
  134. Group by on the text colum throws error
  135. SQL Server Service Account
  136. Query returning duplicate field names
  137. Can SQL Server 2005 Express and SQL Server 2005 be installed on same machine?
  138. Export data from SQL2000 to XML
  139. Backup Disabling Randomly
  140. Table size count
  141. Converting a smallint to an nvarchar
  142. Analsis Manager Parent-Child missing Writeback in Select Advanced Options
  143. How to configure sql server
  144. Firing Triggers from 1 SQL Server to another
  145. Is there a way we can implement business logic by storing it in colums of a table and calling it?
  146. database architecture and table design
  147. Second instance creation tiny wittle problem?
  148. Transposing rows into columns
  149. Stop time duration problem
  150. openrowset drivers msdaora
  151. Create query based on a field that won't be the same value in both tables
  152. 2 sql servers with Access Front-end
  153. Recommended method to obtain SQLDataPath
  154. random row
  155. Backup transaction logs and replication simultaneously
  156. Authors and Instructors Needed!
  157. Stored procedure performance optimization
  158. Another question (IN keyword)
  159. MSSQL acting strange
  160. Need to Change Developers Acct to Windows Authentication
  161. How to find the size of the database dump.
  162. Problem with a foreing key
  163. Follow-up: DTS question
  164. Problem with SQL generated from MS Access
  165. Hanging or lockup issue with SQL Server and Terminal Services 2000 on NT 4 Domain Server
  166. server heartbeat function
  167. Internal SQL Server error when using variable
  168. log shipping - out of sync
  169. Changing datatype from char to datetime
  170. strange performance
  171. SA to Windows Authentication
  172. sql books
  173. DTS global variable question
  174. Database Design
  175. Suggestions on front end development tools
  176. Advise: DTS
  177. Need your help with Microsoft Reporting Services
  178. OUTER JOIN problem
  179. Connecting to Analysis Services using HTTP
  180. Saving text to MS-SQL...
  181. Represent a value list as a table for Outer Join????
  182. Changing Data Format On Select
  183. How to connect to a MSSQL 2000 OLAP Server
  184. Strange SQLCloseCursor Problem
  185. user defined function issue
  186. Variables in SQL Statements
  187. Bulk inserts to Data Warehouse - Best Practices?
  188. SQL Web Administrator calls Visual Studio?
  189. Can't import Access DB into MSDE
  190. Pulling 2 values from 2 textboxes displayed in a third
  191. Showing friendly values in the GUI
  192. XP_SQLMaint
  193. Replace SQL server in multiple server network
  194. Replace SQL server in multiple server network
  195. Need help with query or possible Stored Procedure
  196. CAlling a sp outside a transaction
  197. Linked Server on SQL2000 to DB2 - desperate...
  198. Delete using another table's values
  199. Temporary table problem (maybe)
  200. Microsoft Reporting Service
  201. Front-end tools -- Which is the most productive?
  202. Database server connection
  203. How many records in a table?
  204. Replication: Transactional: Multi Publications, One Subscriber.
  205. Can't change datatype???
  206. How do I change the owner from a table in a database
  207. Timestamp Conversion
  208. Using a Select statment for the name of the field?
  209. Design Question
  210. Mailing Lists
  211. Runtime error data provider or other service provided an efail status
  212. Subform problem with unique-table-property set in access adp
  213. Print the Table Structure
  214. How to print the Table layout
  215. image question
  216. Replication as backup
  217. Outsourcinng is being outmoded
  218. Function that returns highest of two columns?
  219. Synchronization of multiple clients
  220. Removing Tuning Wizard Indexes
  221. Stored procedure to grant all users db_owner
  222. Record Snapshots
  223. convert date to MMDDYYYY
  224. Variable Arg Lists to PreparedStatements
  225. Need help with MS SQL research
  226. [webcast] SQL Server 2005: Integrating SQL, XML, and XQuery
  227. full database backup
  228. Missing Record - Phantom Record
  229. Query could not be processed. Access is forbidden
  230. Using Transaction log to update another database
  231. YUKON Setup Failure
  232. index questions
  233. What is the best way to move data from...
  234. Need help with Stored Procedure
  235. Datetime condition in 'where' - international problem
  236. Extended Stored Procedures DB-Lib Alternative
  237. Choosing DB Edition (Std vs Ent)
  238. DTS to add a field on imported data
  239. Entity Relationship Management Idea
  240. Very long rich text information - datatype?
  241. Remote Sync -- SQL 2000
  242. Optimization advice
  243. DTS Job hangs on 2nd DTS Task
  244. Hide databases in SQL EM from dbo owner
  245. Yukon - will it support sequence object?
  246. DB2 LINKED SERVER
  247. proc argument type array
  248. SQL Server 2000 - how do I change the name?
  249. Problem: mssql locks several records in a specific table, while no one is editing them
  250. Can a new field be added to an existing table.
  251. ERROR 1141 on mySQL creating a User on NT 4.0
  252. Anybody used the universal table broswer?
  253. How to see contents of image column
  254. Table updates -- SQL 2000
  255. Transaction-style Inventory?
  256. SQL Replication
  257. performance problem with linked sybase tables
  258. replicate a database automation
  259. sql batches in vs.net
  260. Report effective permissions for all users?
  261. php integration
  262. SQL Server Components
  263. DBCC PROCCACHE question
  264. OPENROWSET to Access error
  265. ETL library
  266. intermittent openquery error "..The OLE DB provider 'MSDASQL' indicates that the object has no columns.."
  267. Converting Access qrys with logical expressions
  268. Searching question....
  269. Inserting into two tables with one sql statement
  270. Querying single table for multiple summaries - how?
  271. xp_sendmail blocks trigger ?
  272. efficient select
  273. Is a GUID always unique?
  274. Repliation Between 2 Sites
  275. TPC-C Benchmark Kit
  276. Airline Res System Path finder query
  277. Table and Column request as variables error.
  278. JOINs and SUMs Not Giving Expected Results
  279. Capturing events in a DataGrid
  280. Log Shipping Problem/Question.
  281. Need help with query
  282. Weird Cast operator
  283. Attach DB with corrupt .ldf?
  284. Best way to search for all records (Using a Case Statement in a SP)
  285. Transaction Log Rollback
  286. Sql query with a stringfunction
  287. request data from specified time
  288. Disappearing Data -- SQL 2000
  289. temp db
  290. Installing SQL 7 On Workstation
  291. SQLServer 2000 Icoon is not visible in the SystemTray
  292. Updating system tables
  293. Cluster recovery from node failure
  294. How to create a database on pendrive using MSSQL 7.0??
  295. SQL-Query Access by Date
  296. How to query database with multiple queries
  297. How to generate Calculated Field
  298. simple system table question
  299. connecting to sql server (within windows domain) through linux?
  300. Case Statement & View
  301. most recent output
  302. Need to convert a date and time to a different format
  303. How to version control in SQL 2000?
  304. Slow SQL performance with Maximizer Enterprise 8.0 SQL
  305. Database Design Question
  306. Seperating the results of sp_dbfixedrolepermission by fixedbroles
  307. how to force a commit in a sp
  308. Running total count in stored procedure
  309. Changing the server name and IP address
  310. Row-Level Locking
  311. Accessing Estimated Query Execution Plan (QEP) statisitics
  312. HELP! Transaction Log Backup!
  313. Using two select statements in IF Exists
  314. faulting module
  315. [SQL-DMO]The name 'tdb_grabowy1' was not found in the Databases collection.
  316. Zombie Transaction in process -2 Blocking other Transactions
  317. Help on a query
  318. does MSSQL have the ability to do "named row types?"
  319. How to stop mssql
  320. SQL Query help
  321. Suggestions for HUGE DB Design
  322. Performance tuning for a stored procedure
  323. Fastest way to delete hundreds of table triggers and hundreds of stored procedures?
  324. sp_Rename Problem...
  325. xSQL Object 1.5 released - Faster, Better, more Robust
  326. Using Views
  327. Virtual Cube
  328. SQL Statement Count NULL Values
  329. Pass global variable into query through dts?
  330. Order By in Subquery + UNION
  331. Best way to update database behind firewall?
  332. Why use a backup device vs. backup to disk?
  333. Windows Open System/SQL - Sr Systems Analyst Position in PA
  334. Case Expression within a Stored Proc
  335. Sorry, ...
  336. Function to call function by name given as parameter
  337. Calling stored procedure from a C application
  338. Drop temporary tables whilst connected ?
  339. Update Query question.
  340. Database record disappear
  341. Superior SQL Builder version 1.5 released
  342. Query to get column name with specific value
  343. How to find the number of database transactions for a day
  344. HELP! Incomplete data in SQL Server table.
  345. updates across servers
  346. SQL Server Connection
  347. Subquery in FROM clause
  348. Need help on Create View
  349. Insert statement which uses a return value from an SP as an insert value
  350. sql select
  351. Capture existing table
  352. SQL 2000 tape backup fail
  353. Page vs Row locking...
  354. select and insert in one sp
  355. What fields are used?
  356. Looking for SQL Databases for
  357. Write from MS SQL to MySQL
  358. Tables not always replicating
  359. converting access db to mysql
  360. ROW LEVEL SECURITY
  361. Restoring backup from MSSQL6.5 in SQL Server 2000
  362. slow sql update MS SQL 2000
  363. configuring locks in awe system
  364. dropserver
  365. Wildcard doesn't match using LIKE '%' on a varchar field, wierd!
  366. Script to Export SQL Tables to Access
  367. Special Character
  368. How to force unique entries in a linking table?
  369. replication - use legato / veritas /or SQL's native replication
  370. Unable to create object error in sp_SendSMTPMail
  371. SQL server notification services : Help
  372. SQL and XML
  373. Counting Occurences
  374. Cumulative weeks
  375. Empty a table before using DTS to append records?
  376. Disaster - moving databases
  377. How to get String representation of a Hex number?
  378. help with data transformations with outer join?
  379. help with data transformations with outer join?
  380. Simple I think
  381. SQL Server Identity Field
  382. FoxPro ODBC Link Servers and the Dreaded 7399 Error
  383. Simple/General SQL Question
  384. SQL Server Identity Field
  385. DTS - import flat textfile into two separate tables
  386. SQLXML classes deserializing.... nothing....
  387. Help with Error Message
  388. DTS Excel Import, Transform - how do I use "OR" clause in SQL Query
  389. script to spot OS/SFW/HDW changes on my SQL servers?
  390. Database and Log maintenance
  391. Stop/Start MSDE Process
  392. SELECT query help - Zero padding
  393. SQL Server and Clipper/dBase
  394. OUTER JOIN with multiple tables and a plus sign?
  395. SQL Server 2000 & MS SP2
  396. auto-number/Identity column
  397. Clean up old SQL Server logins
  398. BCP Order on SQL Server
  399. SQLExecute takes 100% CPU usage
  400. problem with re adding a login
  401. Question on database/table priviledges with sql server
  402. How to view triggers in SQL server
  403. Secure Replication
  404. call a Oracle stored proc in SQL SERVER
  405. phone book lookup query
  406. Running Scripts
  407. ntext and AppendChunk in ASP
  408. user defined fields best design
  409. In SQLServer SI in ORACLE NO
  410. Reset msde sa password
  411. Any structure on Sql Server like WITH ... SELECT structure on DB2
  412. Error catch in SQL
  413. problem with timeouts
  414. Proper table structure and SQL Server limits
  415. Application times out while doing the updates
  416. Showing Records where count(*) is zero (in a stored proc)
  417. UMS.DLL failure
  418. Isql Command line parameters
  419. import dmp into SQL Server
  420. join or subselect ???
  421. detach database, attach database without log file
  422. General network error
  423. sql statement help
  424. Math function
  425. Can Transactional Replication affect Publishing Server?
  426. Enterprise Manager - slow updates when editing tables
  427. loooong columnnames
  428. Query value in between two columns
  429. Real experiences with 64 bit SQL Server
  430. Create Temp talbe
  431. Select .... where the Item.ID is in this array?
  432. What resources does truncate table use
  433. a player team tables design?
  434. Calling All Dynamic SQL Gods!
  435. deleted my database log file, can't reattach
  436. aliasing two columns in SQL
  437. can not access clustering SQL Server after relocation
  438. Query Help
  439. Best DataType for content system
  440. What do they need to know? - SQL Server
  441. Sorting so 0 is at the bottom
  442. SQL Server Data Types for Local Variables
  443. Cursor Based SQL?
  444. SQL Server import speeds
  445. tuningproblem : materialized table instead of view
  446. Query help needed (JOIN)
  447. Logging into Microsoft Logfiles
  448. MU ONLINE
  449. Compare like data
  450. granting permission to create view
  451. Identifying Connection
  452. Migrating large amounts of data from SQL Server 7.0 to 2000
  453. difficult select distinct query
  454. SQL Server 2000 Table Data Types
  455. ActiveX VBScript problem
  456. Changind date formats
  457. Tansaction/locking MSSQL2000
  458. SQL 2005 Express decided to fight SQL Server 7 ...
  459. msde
  460. Creating tables within my application.
  461. Move TempDB Database off of the SAN
  462. Password protecting XO Profession Control Panel
  463. Updating SQLServer db with VBA
  464. sql question - returning multiple rows as one record
  465. Fix my SQL "WHERE" Statement!!
  466. show tables
  467. logshipping setup with two standby db servers.
  468. Fail over - DNS change
  469. Possible to parse a column in a Select statement?
  470. MMC SQL Server
  471. Help with Trace
  472. Acessing SQL Server over the web with shared IP
  473. repair torn page?
  474. MS SQL 2000 and Windows 2003 Cluster
  475. SQL Mail: Outlook
  476. Delete Records From a Table Using Records in Another Table.
  477. Design flow suggestions needed
  478. More Info: Stored Procedure Security Question
  479. Stored Procedure Security Question
  480. Inflated number of records returned when adding bit field criteria
  481. TSQL Perplexity
  482. Decrypt credit card number for Reporting Services Report
  483. URL Parameters
  484. Partial searches over a lot of fields
  485. How to compare two databases using their DDLs?
  486. Geting event from ActiveX into database
  487. Creating UDT from another UDT
  488. WITH GRANT OPTION
  489. Divide by zero error trapping
  490. New Software 04.08.19
  491. Ignore Error in SP
  492. MS SQL Server Merge Replication
  493. sp_change_secondary_role problems
  494. How to concatenate multiple rows into one field?
  495. Updating more than 10000 records SQL Server 2000
  496. Weird issue on client laptop
  497. [?]Restore and Backup problem
  498. Looking for very good SQL Server DTS books
  499. Looking for very good SQL Server DTS books
  500. Looking for very good SQL Server DTS books
  501. General questions
  502. Storing variables from a user-defined function
  503. Starter question
  504. NON DOMAIN AND DOMAIN CONNECTION
  505. Conversion of Access application to SQL Server
  506. Range query
  507. ON DOMAIN AND NOT ON DOMAIN
  508. Versioning
  509. Using SQL server to process the data
  510. Century date conversions
  511. Tidying up of sproc
  512. Automatically create ODBC connections
  513. memory
  514. Derived Columns in one to many relationships
  515. Log shipping role change
  516. Problem creating indexed views with linked servers
  517. Selecting ONLY records from one table having ALL data contained in other table (GROUP BY?)
  518. Need help with designing a query
  519. Bulk insert into views that select from table on remote server
  520. User Defined Function: Convert String value of Table to Table Object
  521. speeding up Dynamic SP
  522. row-by-row process
  523. Check SQL Database offline
  524. Help with more Advanced functions
  525. DB Growth Issue
  526. Return two rows from one rows data
  527. Storing all stored procedures in one database to minimize different connection strings
  528. SQL aggregate fuction and GROUP BY
  529. sintassi per Creare un file .cub a partire da un cubo mssql
  530. track all changes
  531. Convert table using DTS
  532. help with linked server on sql2000
  533. copy two table
  534. Parametrizar nombre de BD (Espaņol)
  535. Joins versus relationships
  536. Problem with FILENAME as @variable
  537. compact
  538. upgrading hard drives, best way to back up and restore SQL
  539. Drop Index on System Tables
  540. Is there such a thing as too many relationship?
  541. permissions with sql server tables
  542. performance question
  543. One column is nullable on the composite key
  544. SQL Server table changes log
  545. Less than, equal to Operator question
  546. Less than, equal to Operator question
  547. SP waits for a delete trigger?
  548. use db-lib to update database records
  549. iODBC vs unixODBC ?
  550. How to catch an exception?