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. Xquery Support in SQL-Server 2005
  2. equivalent Oracle rownum in SQLServer
  3. Memory leak in SQL Server
  4. Create Second 'sa' Account ('sa2') on SQL 6.5?
  5. SQL Databases compare tool
  6. Need help relocating transaction log file.
  7. C# SQL-DMO ExecuteImmediate
  8. Propagation of event notification when tables are updated.
  9. Which is better for making a copy of a database, restore or DTS?
  10. testing a connection string
  11. Process Info (SQL Server Enterprise - Management - Current Activity)
  12. Slow MDB Linked View
  13. delete last added row -how to
  14. Memory Running Out
  15. Help With Some SQL
  16. Global temp table permissions
  17. How to restore database to point in time (no full backup)
  18. time from datetime
  19. XP_SENDMAIL problem after windows trust with exchange server established
  20. xp_sendmail problem
  21. SQL Server 2000 2GB memory limit?
  22. Formating Numbers with Commas
  23. Formating Numbers with Commas
  24. How to synchronize 2 tables on different sql servers
  25. Constructing Email message
  26. SQL Replication
  27. Does DB-Restore on a different machine omit user/login information ?
  28. SQL DTS package to process a remote OLAP database
  29. How To set delimeters and text qualifiers in a file
  30. How To write An Sql Crosstable Select statment
  31. How To write An Sql Crosstable Select statment
  32. Using DTS to move data to a new table with some datatype changes
  33. HexToInt, vbintoHexStr - fun with CAST
  34. how to add 1 to the field
  35. Help with SELECT Query
  36. Is this correct use of INSTEAD OF Triggers?
  37. Tunneling enterprise manager over https ASP.NET?
  38. Conecting over the Internet for getting data from clients.
  39. Number Data Types...
  40. openrowset - problem in reconnecting to oracle
  41. Help ! Database Still says loading after restore
  42. Help ! Database Still says loading after restore
  43. Select JOIN problem
  44. Wrong syntax in where smth in case ?
  45. Query Analyzer Template files, object browser bug
  46. wil s2k developer edition really work on XP Pro box?
  47. SQL Profiler
  48. DTS of data between two tables, same field names but differnt datatypes
  49. Sending external email from within a Scheduled Job
  50. What is purpose of N in SQL examples?
  51. cursor insert with like '%'
  52. DTS vs Datastage or Informatica
  53. Connecting for entire session, or just when performing an operation?
  54. How do you lock an entire table?
  55. Crosstab queries
  56. User interaction with SQL
  57. BULK INSERT row terminator
  58. Help Please - Backup FileGroup and Restore
  59. MDX Query Book
  60. Stored Proc not updating multiple rows
  61. DBA on mulitiple databases
  62. 7.00.1078_enu.exe on msde
  63. Problem returning a datarow
  64. Storing binary files in MS SQL 2000
  65. simple SQL update
  66. How can I INSERT w/Constraints in other tables?
  67. SQL 2000 - 450+ Databases
  68. Loop through a recordset to populate columns in a temp table
  69. HexToInt and HexToSmallInt
  70. update from ...?
  71. SQL update statement in VB
  72. Field not being updated within Stored Procedure
  73. Complicated SELECT Problem
  74. Book and class
  75. How to delete rows in a table when no primary key is defined
  76. Primary key
  77. Database Modelling in UML
  78. Mails are stuck in the Queue Folder
  79. odbc errors on terminal server
  80. XML to View
  81. SQL problem
  82. DTS package doesn't execute
  83. Totally shameless self-promotion
  84. Sql server authentication not set
  85. Error while running xp_cmdshell
  86. timeout expired w/SQL2K SP3
  87. any SQL guru's out there?
  88. DEFRAG disk drive
  89. Need good idea
  90. Problem using CAST with Zeroed out Field Values
  91. How can i get the details of the error
  92. Very large number of rows
  93. Will MSSQL DB Server perform better with 2k3?
  94. Database design, inherit
  95. How to get the status?
  96. User-Defined string Functions Transact-SQL
  97. Changing the default port number and still connecting
  98. Need advice for process of swapping DBs
  99. How to convert recursive function into recursive stored procedure
  100. Crosstab query
  101. Database Backup Security
  102. Separate an And/Or parameter
  103. Best way for a Set-based query
  104. Recovery and Backup
  105. ODBC and MSDE
  106. Customer IDs without identity
  107. SQL Server -> MS- Access VBA
  108. persisting data for a pluggable tree
  109. What hardware to get?
  110. generating auto sequential numbers
  111. case, joins and NULL trouble
  112. PRIMARY Files
  113. Install Client Connectivity (SQL Server 2000) Only w/ Less Files?
  114. Write only database
  115. sp_elpuser rights
  116. Mail Profile disabled in SQL Server Agent Properties
  117. Linked Servers - Postgres 8.0.2
  118. Ignore Triggers
  119. checking success of a request in a stored procedure
  120. Session State InProc. HELP??????
  121. can't print variable
  122. Timeout Expired Error
  123. Monitoring Data file size
  124. Splitting of database
  125. don't permit manual access to database
  126. Frontpage 2002 & passing an SQL variable
  127. Snapshot replication
  128. SQL - query improvement MAX(date), IN
  129. Problem with dbo.sysindexkeys in SQL 2000
  130. Creating a trace file with the date appended to it's name
  131. SQL Server & MSDE on same machine?
  132. Help with DTS script
  133. Linking Two SQL Servers
  134. Can I ghost an SQL server?
  135. Tables get Locked
  136. MS SQL 2005 Express
  137. Count of related records??
  138. Net Send Failure
  139. Monitoring Deadlocks
  140. Best way to create dynamic update statement
  141. Edit .mdf database
  142. importing a .txt file
  143. SQL Backup procedures...
  144. Installing MSDE2000 for Remote Connection
  145. Noob: Why does this Query work?
  146. concatenate where clause
  147. Moving db across the country- full copy, then differential?
  148. Inserting Records with limited privileges
  149. Scripted delete rows
  150. SCOPE_IDENTITY with ASP
  151. A query that chooses non-matching items
  152. Counting based on a field combination
  153. SQL Server Hot Fix Install Error - dbmslpcn.dll is WRITE LOCKED
  154. Enterprise Manager Collision
  155. Views Are Deleted
  156. quey help
  157. Storing a month
  158. Storing a month
  159. problem with OUTPUT params in Stored procedure
  160. not exist in place of outer join
  161. Dates incorrectly being saved incorrectly. DD and MM swapped round ?
  162. Primary key on combination of nullable fields, at least one not-null
  163. SQL statement
  164. create database at shared hoster site
  165. Refresh data from production to development
  166. SQL datetime from incorrect char(10)
  167. Interesting Problem
  168. SQL Server on Windows XP Workgroup
  169. paradoxical query results?
  170. Int versus Char primay key performance
  171. Tables seem too big - timeouts happening
  172. SQL Server Distribution Server Licensing
  173. SET FMTONLY being added to in-line SQL
  174. Proyectos de Inversion en IT en la UTN
  175. what does [dbo].[Accounts] mean?
  176. web hoster only allows 1 sql server database
  177. problem in registering sql server in enterprise manager
  178. query result as comma-separated list
  179. Last edit time?
  180. Installation Issue
  181. compare
  182. Question with filegroups
  183. help with query
  184. I need help connecting Access 97 to SQL Server 2000
  185. IsNull Evaluation within EXEC
  186. Parameters in Reporting Services
  187. Database Environment Naming Production -vs- Development
  188. restore from command line
  189. SQL to find short, fat and stupid people
  190. Strange Problew with user defined function or stored procedure
  191. Get lowest date
  192. How to reinstall RS Standard Edition on top of expired RS Eval edition
  193. Format display of current row
  194. Connecting Access Front End to Remote SQL Server
  195. Connecting Access Front End to Remote SQL Server
  196. Modifing the row that invokes a trigger from within that trigger
  197. instead-of trigger and contraints
  198. Advantage of Temp Table
  199. VBScrip Type Mismatch Error
  200. Diagram of Master DB
  201. Linked Server gives Internal SQL Server error
  202. prevent DELETE and/or UPDATE
  203. binding SQL server to localhost?
  204. Cache HIT ratio problem
  205. Would you please suggest a good backup tape drive?
  206. Verify dynamically specified table exists
  207. command line
  208. DBA HELP: Performane Tune SELECT, SUM, & CASE
  209. QA tells me my table is ambiguous
  210. Breaking up a Table
  211. query analyzer returning messed up data
  212. Call DTS package from VBA/Excel?
  213. MS SQL Server 2000 / MS Access - ODBC connection question
  214. Lost My Diagrams
  215. New SQL Server and Photos
  216. I dont have any backup of my database, but I have the mdf's and ldf's files
  217. How to get parameter passed to SQL query from access
  218. Creating a view from a linked server
  219. How to comment a server template
  220. How do ITables moved to a new FileGroup ?
  221. Sum of hours by week
  222. Destination Columns Question
  223. Remote access to sql database...permissions
  224. Using MSDE and moving databases
  225. Help! Cygwin X slows down Query Analyzer
  226. How to copy db from test server to local machine running MSSQL2000 Per.
  227. Inserting a record for each separate aggregate (solved)
  228. Import RIS format to SQL Server?
  229. Run DTS in safe way.
  230. Neq to SQL
  231. How to fetch or store a BIGINT using dbExpress and Delphi 2005
  232. Deadlocks in Profiler
  233. DBCC SHOWCONTIG inconsistency????
  234. Access Violation on Saving a DTS Package
  235. Assistance developing Query
  236. Convert variable into dynamic select
  237. Windows groups for SQL Server - what am I doing wrong?
  238. Run DTS package
  239. Primary Key
  240. Move mdf/ldf files for a replicated database
  241. Gather Meta Data
  242. Checking datatypes of a field accoss multiple tables
  243. How to call functions via ODBC
  244. Learning SQL Server 2000
  245. Date problem in SQL Server
  246. Data Parsing in SQL Server views
  247. Changing collation for tempdb and model
  248. Changing collation for tempdb and model
  249. Changing collation for tempdb and model
  250. Design Problem...Please Help!!
  251. Char to Bit
  252. SQL Server Agent - E-Mails
  253. Help with update query linking 3 tables
  254. sp_configure missing - need to allow updates!
  255. Alias has confused me.
  256. sp_configure missing - need to allow updates!
  257. time-series SQL code.
  258. Log Shipping Transaction Log Question
  259. 100,000 lock requests/sec
  260. [TRANSACT]Can't switch from master to another database
  261. "Users shopping for A were also interested in B"
  262. SQL Server Query Optomizer
  263. xp_logininfo and Domain Local groups
  264. "Unable to validate product key"
  265. Help with JDBC Driver
  266. Object Owners.
  267. Compare data in Tables
  268. MS SQL Server 2000 Log Shipping problem
  269. Getting error c:\windows\system32\odbcad32.exe error
  270. International Motivation Survey
  271. Need one Query to obtain results I can only get with two queries
  272. Transaction Replication & Data archiving on SQL server 2000
  273. SQL gurus, please help
  274. Connection problem from Access front end application to SQL Desktop Engine backend
  275. Strage characters displaying in Enterprise Manager 2000
  276. Return Type of COALESCE?
  277. Strage characters displaying in Enterprise Manager 2000
  278. Using DTS Global variable in task
  279. Creating a Select statement with subqueries to 3 other tables...
  280. SQLDMO - Operating System Cannot Run %1
  281. Microsoft Access doesn't support design changes to the version of Microsoft SQL Server
  282. Seaching mulitple fields?
  283. Importing txt files with sql server 2000
  284. Do's and Don'ts of SQL
  285. Reorganize data and index pages
  286. Unhandled exception in mmc.exe: : Access violation
  287. How to solve "Tables or functions 'inserted' and 'inserted' have the same exposed names. "
  288. Openings in an online game company for sql coders
  289. Return results of mulitple select statements in another Stored Procedure
  290. Query runs slower when converted to a view
  291. Poor performance for business day calculation from aspfaq sample
  292. Database design
  293. Limiting active processes?
  294. Delete with 2 keys
  295. Example of Internal SQL Server Error
  296. SQL Server Best Practice Analyzer and T-SQL coding standards
  297. Merge results from two fields
  298. Problems with joins
  299. Big table
  300. How to assign string value to TEXT output parameter of a stored procedure?
  301. Using an if statement
  302. parameterized pass-through queries from Access front-end?
  303. Optimization of a select query
  304. Maintenance Microsoft
  305. A little script help
  306. SQL Server Backup Applications
  307. HELP PLEASE. Query Question.
  308. Help with a Join and Duplicates?
  309. How to extract part of a string
  310. How to upgrade a stored procedure this way?
  311. Help with dynamic SQL Stored Procedure
  312. SubQuery or Temp Table?
  313. Database Design
  314. Inserting data to tables belonging to different databases
  315. howto check the sql server edition from code
  316. Paper about SQL Server 2005
  317. New to MS Sql
  318. Data transfer
  319. Convert a existing SQL Server 2000 database to 2005
  320. System DSN / Registry
  321. SQL SERVER DBA/ ATLANTA
  322. relation & query
  323. remote stored procedure on MSDE
  324. Fastest way to handle the search
  325. naming column names
  326. help on query
  327. MSDE installation fails due to detection of previous installation
  328. Table size and Computed Columns
  329. trying to avoid using cursors!
  330. How to Go From a Database to A Calendar Format?
  331. Help with 1205 Not raised
  332. cursor vs. select
  333. ASP + SQL loads really slow over intranet
  334. Insert produces error
  335. HELP - SQL Server 2000 Install Files needed urgently
  336. User input in SQL2000
  337. Can stored procs run after handle is closed?
  338. Restore Log Fails Msg:3433
  339. Date Display
  340. Error on link Servere
  341. Dev. Team - Keeping Three Tiers in Sync
  342. How to add 2 columns together
  343. SQL 6.5 migrating to SQL 2000
  344. Import XMS into SQL Server 2000
  345. NTEXT vs NVARCHAR for large number of columns
  346. Crear una BBDD desde VB.NET
  347. Memory Mgt in SQL SERVER
  348. Enterprise Manager Date format has changed
  349. Copy a database
  350. How to backup a database into a number of smaller files ?
  351. loop through a datagrid
  352. SQL Like.
  353. MS ACCESS - ON DELETE CASCADE Problem
  354. Query Optimization
  355. sp_send_cdosysmail - Parameter Inside Body of Email
  356. can't do that request
  357. owner of a temp table
  358. Accomodating 'Dummy' Data?
  359. Problem with query and date ranges
  360. Error processing cube with disabled lowest level of shared dimension
  361. Locking Problem: SQL Server
  362. How to copy tables from local machine to remote SQL server
  363. isql error message
  364. Dynamic Build SQL in store procedure based on select
  365. bcp is inserting blank space for empty string
  366. Is it ok to use 100% of SQL Server CPU?
  367. SQL 6.5 - to - SQL 2000 replication
  368. parse XML strings in SQL text field
  369. 3 quick queries
  370. Insert value in an auto-identity column
  371. My db grew 8.2GB in two weeks BUT only 4MB of data added
  372. INSERT violates primary key. Which way out?
  373. Cannot Generate SSPI Context
  374. Distributed transactions with multiple instances of Microsoft SQL Server
  375. email on insert
  376. Enter Default Values for all columns in all tables except Primary Keys
  377. update fields with searched first date record fields
  378. SQL Query Help
  379. Re-using a calculated sub-select field in a view?
  380. What is wrong with this procedure?
  381. help with santax
  382. How can i copy data
  383. Copy field data from table to another
  384. (((((((((( Anyone know where I can pickup MS SQL 02? ))))))))))))))))))
  385. ((((((((( Can someone post SQL 03 program ))))))))))))))))))
  386. NULL values and Indexes
  387. Installing Without CD - Help
  388. Obtaining business hours based on start and end date
  389. Domino VBA
  390. Domino VBA
  391. Is Physical server name stored in the Master database
  392. Renaming logical file names
  393. Utilizing compound indexes
  394. Converting tables to Upper case
  395. Selecting single sorted row from many column
  396. Profiler Trace file format
  397. Join using max value
  398. ZZZZ New text 1/1 New Text Document.txt (1/1) 18
  399. ZZZZ New text 1/1 New Text Document.txt (0/1) 18
  400. filelistonly vs verifyonly
  401. How to connect using C#
  402. audit trail triggers
  403. Checksum not working
  404. Exam 70-229
  405. exec sp_executesql vs. sp_executesql and performance
  406. Need help in Updating multiple rows
  407. CHECK Constraint to prevent a conditional duplicate
  408. Transaction MS SQL
  409. SQL Enterprise Manager and Query Analyzer displaying different Row Counts
  410. Database definitions
  411. urgent
  412. Oledb stored procedure rowset binding
  413. GROUP By clause or DISTINCT clause
  414. Specific Book Recommendation
  415. Question on using patindex
  416. Server not using all available memory.
  417. Grouping columns
  418. Importing Access databases into SQL Server
  419. What is Cardinality
  420. 'Suspect' DB won't open - OS error 32- Help!
  421. Inserts gradually slow down
  422. Need help with complex(?) querie
  423. SQL Union with ORDER BY
  424. isqlw.exe
  425. Restore Production database to Development
  426. Duplicate Reference Numbers using MAX()+1
  427. sql charindex split string
  428. Determine Quarter End and Beginning Dates
  429. owner data objects
  430. Transaction log shrinking... weird behavior?!?!?!?
  431. SQL Server: command line support
  432. Connecting to SQL Server 2000 on another subnet
  433. Count consecutive numbers
  434. Front-end website search using Full-Text
  435. local data
  436. .RMD or RMX. to sql server
  437. Which is better? Int or smalldatetime(MSSQL)
  438. SQL Server 2000 and Windows Server 2003
  439. Many databases vs. 1 database
  440. a new SQL tool to help maintain SQL code is now out
  441. a new SQL tool to help maintain SQL code is now out
  442. Restore database fails because database is in use.
  443. More on mysterious data loss in mssql2k - a possible solution?
  444. read only database performance question
  445. Dynamic Column amount query
  446. Can someone explain this behaviour?
  447. top keyword and sorting
  448. can't do that request
  449. Count the number of cubes
  450. Column Names with a cursor
  451. Sample ASP Script??
  452. Database backups growing exponentially
  453. sql service run as question
  454. How To PROTECT SQL Server Database Files ?
  455. Database Move
  456. Mysterious loss of data from mssql2k
  457. Great News Blog!
  458. Query problem
  459. Having Trouble Installing Reporting Services
  460. Help with query
  461. Interesting issue with Full Text Search
  462. Tough little trigger
  463. SQL Server Performance
  464. Need help with SQL query
  465. Virtual Server 2003 Issue! Access Denied- Admin web screen !!
  466. Process not getting any memory
  467. Dropping FK Constraints in a Stored Procedure
  468. C#, SQL-DMO, Add FileGroup Issue.
  469. Insert SP results into variable?
  470. No longer need default instance of SQL Server
  471. basic sql question
  472. SQL Server 2000 Table Auditing for HIPAA
  473. Log Shipping Problem
  474. sql server replication performance
  475. Recursive Query ??
  476. Getting SUM Function Result
  477. Executing sql statements
  478. Syntax for updating table variables
  479. Handle SQL errors with severity 10
  480. Timestamp problem!
  481. Error 15401 adding login to SQL Server
  482. SQL database structure question
  483. How display number records in query designer VisualStudio.NET
  484. help on a sql request
  485. Views / Stored Procedures / Updating Records
  486. Compairing updated data base.
  487. Calling Encrypt2 function from Sqlserver select query
  488. manage transaction to avoid locks
  489. Virtual Primary Key = Slow
  490. SQL Server Scalability
  491. SQL Mail
  492. Help! SQL Server error - [Microsoft][ODBC SQL Server Driver][SQL Server] Invalid object name ...
  493. access 03 query datashet view problem help
  494. Combine two queries - help please
  495. Import Password Protected File Via DTS
  496. using count somehow
  497. Is it possible to write a format file that skips a few bytes of header in data file?
  498. How do you export?
  499. Dataset Code Debugging
  500. Altering functions and CHECK constraints
  501. Results of SQL SELECT statement into Stored Procedure
  502. Server Reboot
  503. Replication Problem
  504. View Optimization?
  505. SQL Connections using NAT
  506. Updating a field for multiple records
  507. C#: Running DDL to Create Functions.
  508. search engine in SQL server ?
  509. slecting a table using a local variable name
  510. Need help with query that does both timediff & sum
  511. copying data and structure from one database to another
  512. Please help: Create View
  513. Please help: Create View
  514. stored procedure question
  515. Inserting multiple rows with a single INSERT INTO
  516. Cacluated Field
  517. smalldatetime and sorting
  518. Derived Fields
  519. To compare fields between two table
  520. union with sub query
  521. Data import - foreign key question
  522. urgent DB export issue
  523. Vote on a new newsgroup proposal
  524. Windows 2003 - SQL server does not exist or access denied
  525. T-SQL Help
  526. Unable to create a step in a SQLServer Job
  527. Can't connect to SQL Server (developer edition) from another PC?
  528. Help with java connection to MS SQL 2000 with windows integrated security
  529. automatic rename in FROM clause of dependant objects ?
  530. typical audit trail ?
  531. difference between SYSTEM_USER and USER
  532. How to find max from a table by row
  533. HELP: REGEXP accurences count
  534. Inserting to table with dashes in fieldnames
  535. Calculate/create Row Number without identity
  536. sp_attachdb time varies
  537. Exists query with priorities
  538. Date range problem
  539. BCP and Bulk Insert to Linked Servers
  540. How to simplify my endless query. Thanks.
  541. question on trigger/procedure plz reply?
  542. Question on FOR XML issue
  543. sql query help
  544. Help with SQL if statement and adding fields together
  545. treat contiguous records as 1
  546. quick question on SQL server and object support
  547. Null How to handle
  548. Table Design Question
  549. Stored proc location
  550. Change data type during INSERT INTO ?