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