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. Question: Recording login access to SQL Database
  2. Error when setting up ODBC Connection
  3. Performance monitors
  4. Help with phoneBook db design
  5. Text datatype as local variables in Trigger
  6. Migrating to SQL 2003
  7. Adding Time Totals in SQL
  8. Why I can't drop a table
  9. query plan in clear text
  10. How to copy data from backup or data files to new SQL installation?
  11. dynamically trasnpose rows into columns
  12. Sync to databases nightly with BLOB data
  13. Strange FK relationship - how, and is it right?
  14. maintenace plan question please
  15. Deadlocks and Parallel Query Processing
  16. SQL Debugging Tool
  17. Export Data from SQL Enterprise to SQL Express 2005
  18. *=
  19. 1 question about psql table
  20. Please help the performance issue.
  21. When Linking A Server; Only System Tables Are Accessible!
  22. Database security (crosspost)
  23. Database security
  24. datetime
  25. Help with blocking on querying two joined tables
  26. XOR and foreign key constraints
  27. Toad & S2K5
  28. Transactional Replication
  29. SQL relationships and identities
  30. listing SQL Server databases on a network
  31. Disabling Constraint for Bulk Loading
  32. How to Load SpreadSheet in AxSpreadSheet object in VB.NET or C#.NET
  33. Regarding Index Rebuilding
  34. Help with SQL Query !
  35. Role/Person Table?
  36. Should I worry
  37. Concatenation Limits in SQL Server 2000?
  38. Reporting Services
  39. fix for long running transaction problem
  40. Help with select query
  41. Lock table problem
  42. Need Material for "Sybase to Sql Server Migration"
  43. Replication of several satellites into one central db: adding location key ?
  44. Query Optimization: CPU speed or Logical Reads better?
  45. Query Optimization: CPU speed or Logical Reads better?
  46. Using muliple smaller SPs and Functions better than using 1 big SP?
  47. Nested Nodes in XML from a table
  48. Compile/combine the contents of several records.
  49. Is this an efficient way to create a comma string
  50. Excel file import problem
  51. MSE
  52. Get previous record
  53. help with grouping query...
  54. User Loggon Password Changed
  55. 1 SP with dynamic input parameters and multiple rows as the source of the query
  56. Nested Triggers
  57. Getting data from multiple rows into one column
  58. SP and ADO Page Property Not Working Properly
  59. SLEEPING/AWAITING COMMAND question
  60. error handling and bulk insert
  61. Inserting dummy lines and padding
  62. Planning multiple queries
  63. Mini Index?
  64. Select *
  65. cannont create SSPI context (SQL connection problem after 30 minutes)
  66. Databases not showing up in Enterprise Manager
  67. upgrading to SQL 2005
  68. Help needed by deadlock problem
  69. Can REPLICATION on SQL Server 2000 allow dirty reads
  70. 2000 Replication with DB in 65 Compatibility Mode
  71. Application & Database Security Consultant
  72. Can I install VS.net 2005 / VS.net 2002 / SQL 2005 / SQL 2000 in one PC win2000 sp4?
  73. Why upgrade to MS SQL Server (be it 2000 or 2005) from Access (say, 97)?
  74. Extracting and joining header from denormalized table
  75. HELP: Strange Blocking Performance Problem with Simultaneous Queries
  76. Indexing and Queries
  77. problem creating DTS package
  78. splitting a string
  79. Help needed with query syntax
  80. Clustered versus Create table on high speed FILEGROUP
  81. big log file
  82. String case problem
  83. accessing mssql in linux through c++ code
  84. Index Design Recommendation - Examine Column Uniqueness
  85. Index Design Recommendation - Examine Column Uniqueness
  86. PAGEIOLATCH is a lead blocker
  87. Query question
  88. Monitoring replication
  89. Wildcards On Columns?
  90. Show owner of database
  91. Temp Table and SP Advise
  92. Subtracting two columns from diff tables
  93. LOAD .SQL file
  94. Regarding BCP utility
  95. STORED PROCEDURE - passing table name as a parameter
  96. Passing DateDiff rather than Actual Dates as Parameters
  97. log shipping
  98. Problem with spid by sp_who
  99. Format() Function in MS SQL
  100. Select into / Linked Server / Missing IDENTITY attribute
  101. SQL errors, trapping in Server Agent
  102. multi-field primary key
  103. Bulk Import with header in text file
  104. Data grouped by 20 minutes?
  105. About: An INSERT EXEC statement cannot be nested.
  106. CASE problem
  107. An INSERT EXEC statement cannot be nested error.
  108. Strange Performance question
  109. Can't send operator email in SQL Sever 2005
  110. sql 2000 64-bit
  111. Return pkID of last saved record - ASPUpload & @@Identity
  112. connection TCP/IP through the port 1433
  113. Microsoft SQL 2000 Documenter
  114. Using the copy database wizard
  115. Timeout Period in SQL Server 2005
  116. SQL View Performance
  117. Bulk delete on operational data
  118. Performance when using php and mysql
  119. Query Retrieval is slow
  120. Oracle licensing for dual core processors
  121. SQL backup - dun understand
  122. Prepared SQL Plan vs. Procedure Plan
  123. difficult summing query
  124. SQL Query Help
  125. SQL server - script execution time
  126. Subquery headache with Count and GroupBy
  127. query problem
  128. 100 % CPU Usage
  129. How to move two separate databases into one?
  130. Combining INTO with UNION
  131. Enterprise Manager - problem
  132. Tuning API CURSORS
  133. How to drop one of the tempdb files
  134. SQL Equivalent of MAX and IIF
  135. Need help with Count function and temporary tables
  136. Limit saving DTS package to SQL Server
  137. batch replication
  138. problem with Select query
  139. About bcp_init
  140. Scheduled Job Hangs the server
  141. Active directory and SQL 2K
  142. Scheduled job hangs the server
  143. Compressed folder & Query speed
  144. UBOUND
  145. Recordset
  146. Requirement : IBM Process Choreographer
  147. Hiding secret columns from users
  148. Splitting a filename out of a filepath
  149. verify if database exists
  150. SP 4 error
  151. BULK INSERT and APPLICATION ROLE
  152. About dtsrun
  153. Database Problem related Clusterd data
  154. need a DBA Suggestion.
  155. Make a Bunch of Rows from a Table Resemble a Column
  156. Simple SQL Query (To Neglect time from DateTime DataType)
  157. Alex
  158. Log Invalidated after truncate table
  159. stored procedure with array of parameters
  160. HIT and MISS
  161. SQL Server Msg 1105, Level 17, State 2, Line 1
  162. Query returning 1.7million records slow
  163. Best use of inner join
  164. Is this normal
  165. What looks like a basic SQL query still not resolved
  166. Inner join weirdness in DTS
  167. exam ms 70-228
  168. need help
  169. Creating WHERE clauses based on IF (or CASE) STATEMENTS Transact-SQL
  170. Creating WHERE clauses based on IF (or CASE) STATEMENTS Transact-SQL
  171. Optimizing Stored Procedure with Datetime parameter
  172. SQL statement to compute employee pay for a year at different pay rates
  173. adding identity column dynamically
  174. need information on SQL SERVER 2000 with multi-threading CPU
  175. sql query update
  176. There is a question when i work on Linkedserver~Pls kindly help me:)
  177. full text catalog on remote (shared) server
  178. Merge Replication - Adding a new table
  179. QUESTION: Connecting with SQL Admin across domains
  180. Indexes being improperly used when selecting data through a view
  181. SQL-Server DBA-Full Time, Permanent, National Institutes of Health
  182. Optimal search for the nearest date
  183. get the DB index SQL
  184. NEWID()
  185. SQL 2005 Unhandled Exception Error
  186. SQL 2005 Developers Diagram question
  187. flexible back-end data handling in .net + sql project
  188. Query Question
  189. Options to upgrade an SQL 6.5 DB to 2000
  190. DTS package design - Not allaowed link
  191. Is DTS source file's name parameterizable?
  192. Tracking Package Execution Status
  193. Install or not to install Launch Give away version?
  194. Room availability
  195. Concatenating strings from different rows
  196. who knows reporting service
  197. SQL Join with unknown tables - but it works!?!
  198. Star Join
  199. why the MS DTC always stop services automatically ?
  200. SQL server connection problem
  201. working with large numbers
  202. regarding BLOB
  203. How to delete data older than X days, without considering time
  204. Something Basic
  205. Something Basic
  206. Store data horizontally or vertically?
  207. Need security advice on xp_cmdshell, bcp, xml procedure
  208. Linking a table
  209. Simpleton question please
  210. migrating form standard to enterprise edition
  211. how to have the DB diagram
  212. Parse Return value of SYSTEM_USER
  213. DBGEN TPCH Compiling
  214. How to do a JOIN statement for a table with 2, one-to-many relationships.
  215. Bulk Delete
  216. Help with SQL query
  217. Terminal Service cause TimeOut Expired
  218. QUESTION: No Support for SQL 2K on W2K3??
  219. Database optymalization(??)
  220. Filegroup restore problems
  221. Where are the maintenance plans stored in SQL Server 2005?
  222. stored procedure update HUGE PROBLEM
  223. grouping select query
  224. Tables in Parent-Child order
  225. DTS question: 2 source tables, 1 target, 3 connections
  226. Question about Views and sp_refreshviews
  227. Interesting SQL query requirement for <SELECT> menu
  228. Insert
  229. update spends 1800 times more than select
  230. Sql Server 2000 causing TCP/IP to crash?
  231. optional parameter in sql query
  232. commit and rollback problem
  233. tree structure select problem
  234. OpenDataSource trouble with Advantage SQL
  235. newby - AUTOINCREMENT problem.
  236. is WITH ENCRYPTION now safe in SQL2005?
  237. Return Stored Procudure Values
  238. MDF File Still Exists After DROP TABLE
  239. stored procedure
  240. DELETING 100 million from a table weekly SQl SERVER 2000
  241. row level security across multiple columns
  242. BlackBerry Enterprise Server - SQL problem
  243. an unexpected error occured during this operation
  244. mirrored sql servers
  245. How can I tell if a sql server is MSDN or Standard or Enterprise version
  246. sysprocesses memusage sleeping
  247. access MS SQL/ACCESS from linux?
  248. TCP/UDP ports used for Index server OpenQuery
  249. aggregate question
  250. Looking for an opinion
  251. help
  252. Using Query Analyzer with Windows Auth across domains
  253. Whats wrong with my join statement?
  254. Approximate String Searches
  255. Pros / Cons to this approach
  256. learning Microsoft Query Analyzer
  257. Automatic SQL Queries to dump data to folder
  258. Updating a Chunk of data without crashing transaction log
  259. Tables are skipped or export failed error occurs when upsizing MS Access to MS SQL Server
  260. Default charset in sqlserver 2000? / jtds
  261. History of logins or Userids
  262. TPC -H creation script
  263. Torn Page
  264. Is there any REGEXP library for TSQL?
  265. Database design question...
  266. host_name
  267. SQL query question
  268. Unique Constraint on Multiple columns
  269. Stored Procs and db_owner
  270. Information Schema Query Question
  271. Passing authentication from PHP to reporting services
  272. Possible to keep MS Access interface and migrate the MS Access to MS SQL Server?
  273. Mira Laura, toma la direccion web,,, dime algo. MS58
  274. Rendering directory structures
  275. question about log file size when alter Huge table
  276. Use DEFAULT CONSTRAINTs or BOUND DEFAULTs?
  277. Problem with HOST_NAME Function with Linked View
  278. Creating Tables on the Fly
  279. have sql file and want to run it on an ftp connection
  280. unique constraint to a column from another table
  281. DTS Table Import Issue
  282. error message 18542 level 16 state 1
  283. Count(*) Locking up things ...
  284. Distinct Filter in SQL Reporting Services
  285. Multiserver Administration
  286. MSDE and two instances on the same server?
  287. Attaching MDF without LDF
  288. Statement for returning stored procedure params
  289. SQL Server 2000 and 8k limit
  290. advice needed on new server product
  291. Find the Data Bases which can not be Backed up are some resons
  292. Find the Data Bases which can not be Backed up are some resons
  293. String manipulation challenge in SQL
  294. Table Synchronization across databases on the same server
  295. How to take data out of table, restructure the table and then put the data back in
  296. DTSRun causes The Memory could not be "read" application error
  297. Server Listing for TCP connection
  298. Identical database w/ identical stored procedures?
  299. Record , Row number
  300. Record , Row number
  301. Deriving unique rows from historical data
  302. too many connections
  303. User Defined Functions, passing parameters from another udf's results (end result=Crosstab)
  304. Tool for clients
  305. Stripping Punctuation
  306. Create Procedure Output ntext
  307. need to replace replication server with main server
  308. DAO > SQL Server Processes
  309. How to select data
  310. Quarterly trending
  311. Quarterly trending
  312. excluding fields in SELECT statement
  313. mssql ide (front ide)
  314. SQL Server 2000 Error 17805 Invalid buffer received from client
  315. Many data entry tables - which ones hold records?
  316. CAST Command
  317. EnterpriseManager-->Process Info Screen
  318. How to create table names by using macro variable? Thanks!
  319. Sql Server 2005: Get a list of all configured Web Services in the "Object Explorer"
  320. historical data
  321. How do I concatenate text to a sql statement
  322. Table Documentor
  323. DTS vs triggers
  324. Synchronising access and sql server
  325. I wish upon a new server ....
  326. Problem with simple cursor
  327. Foreign and primary keys
  328. Adding an auto-increment column to existing table with a particular order
  329. Derived tables from multiple resultsets
  330. MOM blocking analysis
  331. sum of sums
  332. Identifying results sets when stored procedure called multiple times
  333. simple userdefined function question.
  334. Unable to update view in Sql Server 2000
  335. A way to recursively look up hierarchal data using a lookup table
  336. How is inheritence like data best done in SQL
  337. .dat
  338. Certification is not so easy job.
  339. Query help
  340. Moving Data for Audit - Best Practice
  341. Sequence of columns in primary key
  342. How to display just user defined objects?
  343. Creating Primary key with ODBC
  344. Form Slow, Then Fast
  345. SQL UPDATE - PLEASE HELP
  346. Database Access over Internet
  347. How to Interpret Merge Agent History and Session Detail
  348. determine tables that are Simple recovery
  349. Organization tree
  350. MS SQL Server 2000 - Search a table with 300,000+ records in less then a second or two
  351. Wrong default constraint shown from Object Browser in Query Analyser
  352. Tracking user activities
  353. Column By Column Comparison
  354. Relational Database Usage survey
  355. Unique Selections In Back End
  356. Using "SELECT * " is a bad practice even when using a VIEW instead of a table?
  357. Using "SELECT * " is a bad practice even when using a VIEW instead of a table?
  358. Type Mismatch Error On Bulk Insert
  359. Overflow error
  360. Defragment Heap Tables
  361. Bulk insert
  362. Bulk Insert Command
  363. Update One Based on ANother Table
  364. Help with Query
  365. Is logging the execution time of Stored Procedures with standard settings possible?
  366. registering SQL Server not in domain
  367. Problem with SUM
  368. Join statement
  369. Changing the 6th character of a string?
  370. Bulk Insert Data in Millions - Lock Issue
  371. AutoNumber vs. Key
  372. Any way to optimise this query?
  373. embedded control characters
  374. Errors with SP4 upgrade... Please Help
  375. One-One Relationship
  376. ...Contains more than the maximum number of prefixes. The maximum is 3.
  377. Template function
  378. Sql Server backup vs HP Data Protector (HPDP) -- Do *not* use SQL Server?
  379. LIKE and IN can I combine
  380. database in simple mode yet txn log file can be out of diskspace ?
  381. selecting only the last record in joined table
  382. Sooper Newb Ques: Starting with SQL Server 2000 DE
  383. Schema Diff Tool
  384. Dates in a date range
  385. Temp Table on Linked Server
  386. PK and Timestamp in same table?
  387. Backup for one new DB failing in regular maintenance job Error 3201
  388. SQL Import of LArge Amount of Data
  389. question about like
  390. OpenRowSet with Excel DENIED
  391. SQL Convert function!!
  392. changing indexes
  393. SQL for field names from a table
  394. Change Data Type
  395. seeing FMTONLY/NO_BROWSETABLE ON stuff in the profiler
  396. Import cell data from XLS into SQL table
  397. Please suggest backup software
  398. delete of mirrored rows
  399. Joins: strategy and how-to approach
  400. Unique ID added to a result set
  401. how to determine programatically what output of a sp will be?
  402. Display Money Type using + and -
  403. image data type
  404. Transaction Management
  405. resultset of proc in another proc
  406. new sql version control solution!
  407. Search Advice
  408. PostgreSQL Linked Server question
  409. OPENXML vs BCP
  410. my new function not found
  411. Error installing SQL Server2000: A previous program installation created pending file operations on the installation machine
  412. word xp
  413. Calling a Data Pump task from DTS?
  414. copying server objects
  415. Can't "SELECT" using CREATED_DATE column...help
  416. Multiple level nested Corelated query
  417. Problem with case expression
  418. jacek@karczmarczyk.pl
  419. Error handling when calling external sql-Files
  420. Trouble with SPROC
  421. Unit Testing
  422. Autogrow question
  423. Need help formulating a query
  424. ASP.NET + SQL 2005
  425. Query Help, thanks!
  426. How to save DTS package as an application
  427. How to convert from CHAR to Numeric in the table
  428. Horizotal to Vertical Display
  429. How to check Backup of SQL Server Database
  430. Controlling fields in a select statement by use of parameters
  431. NAMED SET / PIVOT TABLE !! HELP ME
  432. Howto set Access Recordsource onto a "select" sproc
  433. HELP MDX , NAMED SET AND PIVOT TABLES !!
  434. SQL Server 2000 Backup + Restore question
  435. SQL Mail setup
  436. SA can not create users
  437. Multiple entries script...help
  438. Database Replication
  439. Transaction log ???
  440. Problem causing me to have to restore tlogs WITH MOVE
  441. Restoring a missing db
  442. Job invoked by Alert but Alert never occured
  443. Fast Date Ranges Without Loops In SQL Server 2000
  444. Howto setup my user in order to grant him the drop privilege
  445. Performance and second table
  446. How to remove MSDE manually?
  447. Can I speed up this script...help?
  448. Stopping Query Execution from PHP
  449. Simple question
  450. Does DBCC DBREINDEX update stats?
  451. Consolidating Records
  452. Finding the most recient datetime
  453. ordering an int column
  454. SQL Server Hanging
  455. date format
  456. Access Control List (structure) invalid - updating Virtual directory information
  457. parsing varchar fields
  458. iSQL - Blank line at the end of the iSql output file
  459. Error : Difference of two datetime columns caused overflow at runtime.
  460. Error : Difference of two datetime columns caused overflow at runtime.
  461. The SMTP Server in xp_smtp_sendmail
  462. Blocking and Transactions OK?
  463. bit off topic: street name database US
  464. Report Services
  465. SQLColumns crash (Access violation)
  466. updating multiple fields
  467. Howto Format a string in a sproc ?
  468. Connecting Trace info to blocked users?
  469. PASS User Group Austria looking for MS-SQL professionals to take part
  470. Is there a way to find growth in log (ldf) and database(mdf) ?
  471. Any way to find out which SP is updating data in a specific table?
  472. min(date) + 1
  473. searching a list of tables, derived from another table
  474. XP and Replication
  475. Help finding the top 3 zipcodes within the top 5 counties
  476. Syntax to add records if primary key = list
  477. Renaming a Server
  478. Is there any way in a sproc to LOOP thru the records of a table ?
  479. inline if
  480. search on concatenated fields in sql server
  481. Original Data and Log size
  482. Rejoining replicating servers
  483. MDF / LDF
  484. Data Load Query
  485. Linked server
  486. Dynamic data elements for a data collection application
  487. Security Admin on a server with NO public permissions
  488. delete records
  489. bcp header
  490. Delete relationship?
  491. Insert based on a select query
  492. DataDirect Technologies Releases DataDirect XQuery to Simplify XML and Relational Data Integration
  493. Single quote in NVARCHAR string?
  494. How to update 1000s of items in 50 tables
  495. Identity...I need to get the last (or highest number in Identity column)...
  496. Stumped by SQL challenge
  497. SQL Server paged recordset problem
  498. SQL 2000 installation on WinXP Pro problems
  499. Can't connect
  500. Scheduling Database - Design Help!
  501. Scheduling Database - Design Help!
  502. Reg Exp for digits
  503. Converting Binary Image to Readable Text
  504. IDENT_CURRENT and empty table
  505. NOLOCK and READPAST on same table?
  506. Determine fastest query in Query Analyzer
  507. Using IS NOT NULL on column result from subquery
  508. Query Syntax help
  509. Aliased column in stored procedure not seen by datagrid
  510. SQL Mail - MAPI profiles on Windows Server 2003
  511. Best way to tell if a SP is a query Programatically
  512. Tools for design recovery (reengineering) of C# source code with embedded sql statements ?
  513. Extremely Slow Table
  514. how to do text replacements
  515. SQL Server bouncing connections
  516. Dont backup if Database hasnt changed
  517. The "right" way to distribute a database to end-user
  518. Why dosn't IIF work here?
  519. saving output from multiple queries
  520. Can someone help me with multiple "Left Outer Joins"?
  521. Can someone help me with multiple "Left Outer Joins"?
  522. Need Help with "Left Outer Join"...
  523. Removing white spaces in a varchar column
  524. Help on a SQL query
  525. oracle pl/sql -> sql server
  526. Index corruption on table without key: what could be the reasons ?
  527. SCOPE_INDENTITY() Not Returning
  528. Script to search for a string in all varchar columns in all tables in a database?
  529. VB 6 & SQL Database: How can I create reports with charts ?
  530. Saving query plan
  531. Output stored procedures as text problem
  532. XML generation issues
  533. How to count
  534. How to override zero rows returned
  535. Monitoring Software
  536. xp_sendmail problem - body message breaking onto new line..
  537. Find the Stored procedure
  538. Round problems in SQL 2000
  539. Changing From Windows To Mixed Authentication
  540. sql datatype help
  541. Systematically determine DRI problem(s)
  542. Any SELECT Statement Gurus Out There?
  543. Import Spreadsheet error
  544. How Do I Prevent SQL 2000 From Posting This Message To The Event Viewer - Application Log
  545. desinstall MS SQL
  546. XML Tables generation
  547. desinstall MS SQL
  548. Help with calling a job from Stored P and VBA......HELP
  549. About adding a new column...
  550. Return from store procedure.